Kbase P18120: Receiving compile error creating HelloWorld Stored Procedure Example from the Progress SQL-92 Guide
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/5/2009 |
|
Status: Verified
SYMPTOM(s):
Receiving compile error creating HelloWorld Stored Procedure Example from the Progress SQL-92 Guide and Reference book.
[JDBC Progress Driver]:error in compiling the stored procedure.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
This line of code is missing in the example.
Insert_HelloWorld.execute();
FIX:
The statement "Insert_HelloWorld.execute();" must be inserted prior to the END statement. Refere to the following Example:
CREATE PROCEDURE HelloWorld ()
BEGIN
SQLIStatement Insert_HelloWorld =
new SQLIStatement("INSERT INTO HelloWorld(fld1) values ('HelloWorld!')");
Insert_HelloWorld.execute();
END