Re: Getting results from a Stored Procedure via ADO

see www.microsoft.com/data

there's a section about ADO with some great articles ...but i have a problem, I can only use integer parameters and I can't put "string" parameters to work like I describe next...

ADO - Calling StoredProc with "string" Parameters

I can't put this to work any way....
Why is it not possible to use "string" parameters to call an SP? With integer parameters all goes well as in all public examples....

Does any one knows why?
Thanks for reading, Vitor Mendes

««««««««««««««««««««««««««««««««««««««««««««««« Active Server Pages
VBSCRIPT Set cmd = Server.CreateObject("ADODB.Command") Set cmd.ActiveConnection = ligacao

cmd.CommandText = "sp_uidseq"
cmd.CommandType = adCmdStoredProc

'# ERROR in this line...
cmd.Parameters.Append cmd.CreateParameter("uidnome", adVarChar, adParamInput)

cmd.Parameters.Append cmd.CreateParameter("uidsaida", adVarChar, adParamReturnValue)
cmd("uidnome") = COD_APLICACAO
cmd.Execute
»

««««««««««««««««««««««««««««««««««««««««««««««« Stored Procedure
CREATE PROCEDURE sp_uidseq

        @uidnome varchar(3),
        @uidsaida varchar(6) output AS

««««««««««««««««««««««««««««««««««««««««««««««« ADODB.Parameters error '800a0e7c'
The application has improperly defined a Parameter object. /helpdesk_v1_02/public.asp, line 247
»

ECatz wrote in message <75cle9$g62$1_at_imsp009a.netvigator.com>...
>I have written a Stored Procedure in Oracle that returns a generated
 number.
>
>This stored procedure works fine when executed within Oracle itself.
>
>Is it possible to retrieve this number using ADO??
>
>Thanks
>
>-ECatz
>
>
Received on Tue Dec 22 1998 - 00:00:00 CST