🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4984

Stored Procedure Problems

#4984
From: John McDonald
Date: Wed, 15 Aug 2001 21:20
26 lines
1589 bytes
Hi,

I am trying to get a return value from an Oracle 8i stored procedure.
Here's the code:

 AnsiString txt= "psm_util.set_psmpst_ack(101,725,'testing')";
 ADOStoredProc1->Connection = ADOConnection1;
 ADOStoredProc1->ProcedureName = WideString(txt).Detach();
 //    DataSource1->DataSet = ADOStoredProc1;
 ADOStoredProc1->ExecProc();

The procedure executes OK without problems, but I can't find
the return value anywhere.  I've tried setting up a return value
parameter on ADOSotedProc1..I get nothing.  I also tried the
suggestion in ADO help:

  DataSource1->DataSet = ADOStoredProc1;  //Then what???

Where should the return value show up???  Does anyone have an
example of executing stored procedure with a return value??  This
is my first time using ADOStoredProc and I think I'm missing something
basic...

Thx,

John
Technical Details
Message-ID: <3b7ae1f4.2584426@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,be1ee1f1730e9a28,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-15 14:32:34 PST
From: mcdonald@airtalk.com (John McDonald)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Stored Procedure Problems
Date: Wed, 15 Aug 2001 21:20:33 GMT
Organization: System Studies, Inc.
Message-ID: <3b7ae1f4.2584426@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 1.11/32.235
NNTP-Posting-Host: 209.78.255.151
X-Trace: dnews 997910614 209.78.255.151 (15 Aug 2001 14:23:34 -0700)
Lines: 31
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews