Coldfusion & Stored Porc. with array parameter

I want to call a procedure with array parameter from ColdFusion.

My procedure is (Oracle8i):

create type array3 is varray(3) of number ;
 
create or replace procedure Array_1(rt_ array3, value_ out number)
is
  i number;
  nreturn_ number;
begin
  for i in 1..3 loop
   nreturn_:=rt_(i)+1;
  end loop;
  value_ := nreturn_;
end Array_1;
/

How can i write the code to call this procedure in ColdFusion?
hieutdAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
CF_SpikeConnect With a Mentor Commented:
I haven't worked much with Oracle, but there is a good article on stored procedures and oracle on the allaire website:

http://www.allaire.com/Handlers/index.cfm?ID=8353&Method=Full

Spike
0
 
Scott BennettManager TechnologyCommented:
what is the data type of the in variable rt_ array3?
0
 
Scott BennettManager TechnologyCommented:
I am going under the assumption that rt_ array3 is VARCHAR. If not then the cfsqltype attribute for the first <cfprocparam> will have to be changed to the proper type.

IF you have any questions or need more expplanation let me know.

-Scott

---------------------Begin Example Code-------------


<CFSTOREDPROC PROCEDURE="Array_1"
    DATASOURCE="YourDataSourceNameGoesHere"
    >
     
<CFPROCPARAM TYPE="IN"
    Value="Value_Of__Input_For_rt_ array3_Goes_Here"
     cfsqltype="CF_SQL_VARCHAR"
    >

<CFPROCPARAM TYPE="OUT"
     Variable = "value_out_Variable_Name"
     cfsqltype="CF_SQL_INTEGER"
    >

</CFSTOREDPROC>

---------------End Example Code---------------------------
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.