Running stored procedures in Progress OpenEdge 10B

[nukn]

Hello,
I'm new to Progess and I am learning how to create stored procedures. After I write this in SQL Explorer:
create table test_helloworld (text varchar (20));
create procedure hello_world ()
begin
SQLIStatement Insert_HelloWorld = new SQLIStatement ("INSERT INTO test_helloworld (text) VALUES (('Hello')");
Insert_HelloWorld.execute();
end;
Everything is fine, and the procedure is created. But when I'm trying to run it like:
call hello_world();
I get a mistake:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022
[JDBC OpenEdge Driver]:[]Failed during dynamic load of Java dynamic library. Reason = [126]ͥ 䥭 㪠砭 쮤㫼.
[jvm].
Does anybody knows how can this be helped? Thank you in advance.

 

[Casper]

Maybe setup problem?

KB: 99800

Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
OpenEdge 10.x
Progress 9.1D

SYMPTOM(s):
SQL-92 stored procedure returns an error when called (executed) from
SQL-Explorer.
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022

[JDBC OpenEdge Driver]:Failed during dynamic load of Java dynamic
library. Reason = [126]The specified module could not be found.
[jvm].

Running SELECT * from sysprogress.sysprocedures verifies stored
procedure stored in database.
CAUSE:
Java environment is not set properly for executing SQL procedures.
FIX:
To correct the problem do the following steps:
1. Launch Progress proenv window
2. Shut down the database
3. Run sql_env at the proenv prompt:
proenv>sql_env
CLASSPATH=C:\Progress\OpenEdge\java\prosp.jar;C:\Progress\OpenEdge\java\jdbc.jar
;
PATH=C:\Progress\OpenEdge\jre\bin\client;C:\Progress\OpenEdge\BIN;C:\WINDOWS\MS\
SMS\CORE\BIN;C:\PROGRESS\OpenEdge\jre\bin\hotspot;C:\WINDOWS\system32;C:\WINDOWS
;C:\WINDOWS\System32\Wbem;C:\PROGRA~1\ABSOLU~1;C:\Progra~1\Symantec\pcAnywhere\
.
DONE setup the sql environment
4. Restart the database
5. Restart SQL Explorer and call the stored procedure.

HTH,

Casper.