can't read output variable calling a PROCEDURE on ORACLE

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

dodonovi
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 10.02.2009, 17:39

can't read output variable calling a PROCEDURE on ORACLE

Postby dodonovi » 10.02.2009, 18:00

hi..

i'm using ZeosLib 6.6.4-stable in Borland Builder 5
my connection with Oracle DB is OK (via VPN) the SELECT
queries are good.

i'm tryng to CALL a Stored Procedure on ORACLE 10g2
the procedure is like this:
procedure NAME( par1 in number, par2 out varchar2 ) ....

i try a lot of solution with TZQuery and TZSQLProcessor
i made the parameter run time or design time..

for example a "no error" running solution is this:

SQL= "CALL NAME( 1, :xx)"

where i have defined a parameter like "xx",
DataType= ftString,
ParamType= ptOutput

i made ExecSQL() or Open() commands
and my parameter XX is void
i have no return FIELDS..

i think the query CALL was running ok, but i don't how read the out
value par2 (xx)
can someone help me ? do you need more details ??

thanks Davide.

humantool
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 10.02.2009, 17:16

Postby humantool » 11.02.2009, 13:00

Hi,
I've seen query build in delphi by the dbexpress components that where like this :

Code: Select all

insert into "TESTTW" ("NUMTEST", "NOMTEST", "MEMOTEST", "BLOBTEST") values (:1, :2, EMPTY_CLOB(), EMPTY_BLOB()) RETURNING MEMOTEST, BLOBTEST INTO :3, :4

Maybe the key word is "returning" for you ?


Return to “6.5.1 (alpha) - 6.6.x (beta)”

Who is online

Users browsing this forum: No registered users and 1 guest