Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Progress 9.x
SQL Explorer
Progress Explorer

SYMPTOM(s):

Error Compiling Stored Procedure

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

CAUSE:

- Somehow, when the database server is started through Progress Explorer, it does not set up the Java environment properly and hence gives the above error.

FIX:

Follow these steps to resolve the error:

1) Check to see if any of the lines are cut short and are carried to the next line:

For example, if you have following code in SQL Explorer:

    CREATE PROCEDURE mytest()
    BEGIN
    SQLIStatement n_stmt = new SQLIStatement("INSERT INTO RSA_USER
VALUES(1,2)");
    END

Move the code of line 'VALUES(1,2)");' up, appending to the previous line.

2) If your database is started through Progress Explorer, shut it down and start it again using DOS command prompt.