I'm trying to create a java stored procedure using SQL Explorer but I
continously have the following error:

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20141
[JDBC Progress Driver]:error in compiling the stored procedure

If I go to my progress working directory, I'm able to compile the
stored procedure from the command line. Do I have to set any
environment settings in order to create stored procedures? Any other
ideas?

thanks

Thomas