?
Solved

Coldfusion & Stored Porc. with array parameter

Posted on 2001-07-12
3
Medium Priority
?
212 Views
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)
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?
0
Comment
Question by:hieutd
[X]
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
3 Comments
 
LVL 4

Accepted Solution

by:
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:

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

Spike
0
 
LVL 14

Expert Comment

by:Scott Bennett
ID: 6281330
what is the data type of the in variable rt_ array3?
0
 
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.

-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

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