Getting the returned error string from a PL/SQL procedure

Article View: borland.public.cppbuilder.database.multi-tier

Article #551

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#551

From: Jerri Chiu
Date: Mon, 16 Jul 2001 21:47

19 lines
1486 bytes

Hi,

I want to execute a PL/SQL procedure using a TDataSource + TQuery like this:
strSQL.sprintf("CALL proc_x"
                "('%s', %s, %s)",            <=??
                strParam.c_str(),
                strReturnCode.c_str(),    <=??
                strErrorString.c_str());    <=??

qUpdate->SQL->SetText(strSQL.c_str());
qUpdate->ExecSQL();

where proc_x returns a ReturnCode and an ErrorString, I would like to use
strReturnCode and strErrorString to store these returned values, how do I
rephrase my sprintf statement?  in other words, how should the proc_x be
called?

Thanks much
Jerri Chiu

Technical Details

Message-ID: <3b536117$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!nntp-relay.ihug.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: fcd2b,5dabb98860a38d57,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-07-16 15:00:17 PST
From: "Jerri Chiu" <jeje@home.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Getting the returned error string from a PL/SQL procedure
Date: Mon, 16 Jul 2001 14:47:53 -0700
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 130.110.218.115
Message-ID: <3b536117$1_2@dnews>
X-Trace: dnews 995320087 130.110.218.115 (16 Jul 2001 14:48:07 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews