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
Solved

Coldfusion & Stored Porc. with array parameter

Posted on 2001-07-12
3
203 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
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
CF_Spike earned 300 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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. 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 : Open Page or Post…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

829 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