Article View: borland.public.cppbuilder.database.ado
Article #5606output parameters in TADOStoredProc
From: Juan Carlos
Date: Wed, 04 Apr 2001 15:05
Date: Wed, 04 Apr 2001 15:05
24 lines
1690 bytes
1690 bytes
Hi, All
I need to RETURN a String parameter from Oracle 8.1.6.0.0 DataBAse using TADOStoredProc. When I try, I gain this erro
message "Parameter object is improperly defined.
Inconsistent or incomplete information was provided".
When I use a ftInteger DataType it work properly but when I
use ftString don't.
This is the Stored Procedure prototype
create or replace procedure SP_CA_URAVOZ(codigo in varchar
,valido out number
,outstring out varchar)
and this is my code
ADOSP1->Parameters->AddParameter();
pcount = ADOSP1->Parameters->Count - 1;
ADOSP1->Parameters->Items[pcount]->Name = "var2";
ADOSP1->Parameters->Items[pcount]->Direction = pdOutput;
ADOSP1->Parameters->Items[pcount]->DataType = ftString;
ADOSP1->ExecProc();
does any one help me?
thanks in advance
Technical Details
Message-ID:
<3acb3848$1_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,ff4e01ac7cf693b3,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-04-04 08:15:09 PST From: "Juan Carlos" <juan@lm.com.br> Sender: "Juan Carlos" <juan@lm.com.br> Reply-To: "Juan Carlos" <juan@lm.com.br> Subject: output parameters in TADOStoredProc Newsgroups: borland.public.cppbuilder.database.ado X-User-Info: 200.182.209.214 200.182.209.214 NNTP-Posting-Host: 207.105.83.65 Message-ID: <3acb3848$1_2@dnews> Date: 4 Apr 2001 08:05:44 -0700 X-Trace: dnews 986396744 207.105.83.65 (4 Apr 2001 08:05:44 -0700) Lines: 25 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews