asp to call Oracle stored procedure

[eddie wang]

Here is the ASP code that has problem: ADODB.Parameters error Parameter
object is improperly defined... Inconsistent or imcomplete information
was provided.
I have copied my Oracle stored procedure as well. Please help.


Set paramId = cmdStoredProc.CreateParameter("graph_list", adVarChar,
adParamOutput)
cmdStoredProc.Parameters.Append paramId



create or replace PROCEDURE get_graph_list(seq_id_in in number,
graph_list out varchar ) IS
cursor list is
select field_nm name from los_aggregate_procedure_list_f where
seq_id=seq_id_in
union
select rc_nm name from los_aggregate_procedure_list_r where
seq_id=seq_id_in
union
select area_nm name from los_aggregate_procedure_list_a where
seq_id=seq_id_in;
BEGIN
graph_list:=null;
for list_rec in list
loop
graph_list :=graph_list||list_rec.name||'; ';
null;
end loop;
END;


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!