Coldfusion & Stored Porc. with array parameter

Posted on 2001-07-12
Medium Priority
Last Modified: 2013-12-24
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)
  i number;
  nreturn_ number;
  for i in 1..3 loop
  end loop;
  value_ := nreturn_;
end Array_1;

How can i write the code to call this procedure in ColdFusion?
Question by:hieutd
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

CF_Spike earned 600 total points
ID: 6279768
I haven't worked much with Oracle, but there is a good article on stored procedures and oracle on the allaire website:


LVL 14

Expert Comment

by:Scott Bennett
ID: 6281330
what is the data type of the in variable rt_ array3?
LVL 14

Expert Comment

by:Scott Bennett
ID: 6281372
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.


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

    Value="Value_Of__Input_For_rt_ array3_Goes_Here"

     Variable = "value_out_Variable_Name"


---------------End Example Code---------------------------

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question