Retrieving Results

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

Article #5008

Back to borland.public.cppbuilder.database.ado Previous Next

#5008

From: John McDonald
Date: Mon, 20 Aug 2001 15:56

23 lines
1518 bytes

Hi,

I am trying to execute a stored procedure in Oracle 8i that
returns an integer value.  I can get the stored procedure
to execute OK but I cannot find the return value anywhere???


    ADOCommand1->Connection = ADOConnection1;
    ADOCommand1->Parameters->Clear();
    ADOCommand1->CommandText = WideString(Text).Detach(); 
       //Text = "util.set_psm_ack(3456,321,'Testing..')";
    ADOCommand1->CommandType = cmdStoredProc;
    ADOCommand1->ParamCheck = false;
    ADOCommand1->Execute();
    ADODataSet2->Recordset = ADOCommand1->Execute();

Everytime ADODataSet2->Recordset = ADOCommand1->Execute(); 
executes I recieve a stack overflow exception.  How can I
retrieve the results from the stored procedure?? 

Thx,

John

Technical Details

Message-ID: <3b8131d6.570235@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!novia!novia!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,79925ae67771c000,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-20 09:07:06 PST
From: mcdonald@airtalk.com (John McDonald)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Retrieving Results
Date: Mon, 20 Aug 2001 15:56:22 GMT
Organization: System Studies, Inc.
Message-ID: <3b8131d6.570235@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 1.11/32.235
NNTP-Posting-Host: 209.78.255.240
X-Trace: dnews 998323000 209.78.255.240 (20 Aug 2001 08:56:40 -0700)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!novia!novia!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews