Consultor Eletrônico

Status: Verified

SYMPTOM(s):

SQL-92: Error (10713) executing a stored PROCEDURE using the Progress SQL Explorer Tool

[JDBC OpenEdge Driver]:Syntax error in SQL statement at or about "("INSERT INTO Hello(test) VALUES('HELLO " (10713)

=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210056
[JDBC OpenEdge Driver]:Syntax error in SQL statement at or about "("INSERT INTO Hello(test) VALUES('HELLO " (10713)

The error is generated when executing the following SQL-92 script from the Progress SQL Explorer tool:
DROP PROCEDURE HelloWorld;
CREATE PROCEDURE HelloWorld ()
BEGIN
SQLIStatement Insert_Hello = new SQLIStatement
("INSERT INTO Hello(test) VALUES('HELLO WORLD!')");
Insert_Hello.execute();
END;
COMMIT;

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

CAUSE:

The statement
SQLIStatement Insert_Hello = new SQLIStatement
("INSERT INTO Hello(test) VALUES('HELLO WORLD!')");
is broken on two lines. Multiple line statements are not supported by the Progress SQL Explorer Tool.

FIX:

Write the offending statement on one line:
DROP PROCEDURE HelloWorld;
CREATE PROCEDURE HelloWorld ()
BEGIN
SQLIStatement Insert_Hello = new SQLIStatement ("INSERT INTO Hello(test) VALUES('HELLO WORLD!')");
Insert_Hello.execute();
END;
COMMIT;