Create Stored Procedure: Getting SQL Exception 1 === SQLState=HY000 ErrorCode=-20176

[vkvisva]

I am trying to create a simple stored procedure (tried using sqlexp as well as a jdbc tool). While other SQL operations work, I am unable to get this working:
A trivial Hello World case: (Error while compiling stored procedure)

@echo true;
@autocommit true;
CREATE PROCEDURE "HelloWorld" ()
BEGIN
String sqlStmt = "INSERT INTO PUB.TESTTABLE (data) values ('Hello World!')";
SQLIStatement InsertHelloWorld = new SQLIStatement (sqlStmt);
InsertHelloWorld.execute();
END

Any help appreciated.


Thanks,
Visva