I would like to create my first stored procedure, so I have created what I think is an extremely simple (so it should work, right?) procedure that does basically nothing.
My Query (executed through SQL Explorer tool)
create procedure MyFirstProcedure ()
BEGIN
string strHello = new String (20) ;
END
The Response:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210058
[JDBC OpenEdge Driver]:Error from Java compiler. Compiler messages follow.(10727)
Note that there are no Java errors shown!
1. Where can I go to read the errors? Logfile?
2. Since I've never done this successfully before, I may have something misconfigured... My DB is definitely running and connected, and I can execute other queries against it.
Any help appreciated - Thanks!!!
My Query (executed through SQL Explorer tool)
create procedure MyFirstProcedure ()
BEGIN
string strHello = new String (20) ;
END
The Response:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210058
[JDBC OpenEdge Driver]:Error from Java compiler. Compiler messages follow.(10727)
Note that there are no Java errors shown!
1. Where can I go to read the errors? Logfile?
2. Since I've never done this successfully before, I may have something misconfigured... My DB is definitely running and connected, and I can execute other queries against it.
Any help appreciated - Thanks!!!