🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: output parameters in TADOStoredProc

#5519
From: Juan Carlos
Date: Thu, 05 Apr 2001 13:08
45 lines
2241 bytes
Thank very much,
this parameter ADOSP1->Parameters->Items[pcount]->Size  =  ( a value greater than 0 ) is the goal.
the default valor is 0.

Juan
    
"Alan Lichtenstein" <alanl@sss.sungard.com> wrote:
>This may be worth a try....  Have you tried setting:
>
>    ADOSP1->Parameters->Items[pcount]->Size  =  ( a value greater than 0 )
>    ADOSP1->Parameters->Items[pcount]->Value = NULL;
>
>
>
>
>Juan Carlos wrote in message <3acb3848$1_2@dnews>...
>>
>>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: <3acc6e44$1_2@dnews>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews
References: <3acb3848$1_2@dnews> <3acba712$1_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ff4e01ac7cf693b3
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-05 06:12:02 PST
From: "Juan Carlos" <juan@lm.com.br>
Sender: "Juan Carlos" <juan@lm.com.br>
Reply-To: "Juan Carlos" <juan@lm.com.br>
Subject: Re: output parameters in TADOStoredProc
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 200.182.209.214 200.182.209.214    
References: <3acb3848$1_2@dnews>  <3acba712$1_1@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3acc6e44$1_2@dnews>
Date: 5 Apr 2001 06:08:20 -0700
X-Trace: dnews 986476100 207.105.83.65 (5 Apr 2001 06:08:20 -0700)
Lines: 46
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews