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 !
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 !