output parameters in TADOStoredProc

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Juan Carlos Wed, 04 Apr 2001 15:05

#5606

Author: 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

Re: output parameters in TADOStoredProc

#5614

Author: Alan Lichtenstein
Date: Wed, 04 Apr 2001 22:57

35 lines
2013 bytes

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
>

Re: output parameters in TADOStoredProc

#5519

Author: 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
>>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads