Problem in Retrieving An Array From Oracle Stored Procedure !

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]

Posted by Joe on May 22, 2002 at 9:5:36:

create or replace type char_varray is varray(200) of char(15);
/

create or replace procedure getusers(username out nocopy char_varray) is
cursor users_cursor is
select username from users;

percount number default 1;
begin
username := char_varray();
for users_record in users_cursor loop
username.extend;
username(percount) := users_record.username;
percount := percount + 1;
end loop;
end;
/

I am able to get the array of values in SQL*Plus, but, NOT in ASP. The ASP code I use:

Set cmdStoredProc = Server.CreateObject("ADODB.Command")
Set cmdStoredProc.ActiveConnection = Conn ' a valid database connection
cmdStoredProc.CommandText = "getusers"
cmdStoredProc.CommandType = 4 'adCmdText

T = (&H2000 OR 129) 'adArray or adChar
set param = cmdStoredProc.createparameter("username", T, 2, 2000, "")
cmdStoredProc.parameters.append param

cmdStoredProc.Execute

When I load this page, I am getting the following error:

ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

I am able to retrieve one single char value. NOT an array of char values. I use ADO 2.7.

Any help would be greatly appreciated.

Thanks.

Follow Ups:

• Plz--Urgent: retrieving Hexa decimal value from Stored Procedure Y.Satish Babu 06:20:36 2/19/04 (0)
• Re: Problem in Retrieving An Array From Oracle Stored Procedure ! Alex Saenger 11:40:32 6/04/02 (0)

Post a Followup

Name:     
E-Mail:   
Subject:  
Message:

Optional Link URL: 
Link Title:        

      

[ Follow Ups ] [ Post Followup ] [ Intranet eXchange ] [ IDM Home ]