Article View: borland.public.cppbuilder.database.ado
Article #5519Re: output parameters in TADOStoredProc
From: Juan Carlos
Date: Thu, 05 Apr 2001 13:08
Date: Thu, 05 Apr 2001 13:08
45 lines
2241 bytes
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!dnewsReferences:
<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