Oracle XE 10g Stored Proc Problem EZSQLException
Posted: 09.06.2010, 13:30
Hi all
i'm using Zeos 6.6.6. and Lazarus 0.9.28.2 on Windows XP.
As DB i use Oracle XE 10g.
I have a simple Procedure in Oracle:
CREATE OR REPLACE PROCEDURE WTRANS.testx(ein in varchar2, aus out varchar2) AS
BEGIN
aus := ein;
END ;
/
I has one in Parameter an one OUT Parameter.
Now i try to call this Proc in my Program.
I have a ZConnection and a TZStoredProc on my Form.
The TZStoredProc has the name "test"
and i uses this Code:
test.Params.clear;
test.Params.CreateParam(ftString,'ein',ptInput);
test.Params.CreateParam(ftString,'aus',ptOutput);
test.ParamByName('ein').asstring := 'bbb';
test.execproc;
st := test.ParamByName('aus').asstring ;
But on the call of execproc i get always the following error:
Project project1.exe raised exception cass 'EZSQLException' with message: Unsupported operation
Can anybody help, Thanks
André
i'm using Zeos 6.6.6. and Lazarus 0.9.28.2 on Windows XP.
As DB i use Oracle XE 10g.
I have a simple Procedure in Oracle:
CREATE OR REPLACE PROCEDURE WTRANS.testx(ein in varchar2, aus out varchar2) AS
BEGIN
aus := ein;
END ;
/
I has one in Parameter an one OUT Parameter.
Now i try to call this Proc in my Program.
I have a ZConnection and a TZStoredProc on my Form.
The TZStoredProc has the name "test"
and i uses this Code:
test.Params.clear;
test.Params.CreateParam(ftString,'ein',ptInput);
test.Params.CreateParam(ftString,'aus',ptOutput);
test.ParamByName('ein').asstring := 'bbb';
test.execproc;
st := test.ParamByName('aus').asstring ;
But on the call of execproc i get always the following error:
Project project1.exe raised exception cass 'EZSQLException' with message: Unsupported operation
Can anybody help, Thanks
André