🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

output parameters in TADOStoredProc

#5606
From: Juan Carlos
Date: Wed, 04 Apr 2001 15:05
24 lines
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!dnews

Show 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