[JDBC Progress Driver] ErrorCode=-210022

[jvd]

Hi,all,

I'm using a Progress 91d database, Merant 3.6 ODBC driver and the Progress SQL explorer.

I'm trying to use stored procedures.

I can store a procedure with:

CREATE PROCEDURE dozen_jvd1 ()
BEGIN
SQLIStatement Insert_dozen_jvd1= new SQLIStatement ("INSERT INTO PUB.dozen(bijzonderheid) values (’Hello World!’)");
END

(if I run it again, it says that it already exists, so I assume it's stored)

The problem is when I call this procedure:
CALL dozen_jvd1() ;
commit;

I'm getting this error:
=== Statement 1. ===
CALL dozen_jvd1();
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022
[JDBC Progress Driver]:.
Errors 1.
=== Statement 2. ===
commit;

Statements: 2; Updates 0; Rows 0; Errors: 1; Warnings: 0. (8926)

Anyone got this working ?
(These are simple examples from the manual)

Thanks in advance for your answer/comment/tip !

 

[jvd]

I copied this from the pdf manual:
("INSERT INTO PUB.dozen(bijzonderheid) values (’Hello World!’)");

It had to be like this:
("INSERT INTO PUB.dozen(bijzonderheid) values ('Hello World!')");

(notice the difference in the quotes around Hello World !