Solved

Coldfusion & Stored Porc. with array parameter

Posted on 2001-07-12
3
201 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

New! My Passport Wireless Pro Wi-Fi Mobile Storage

Portable wireless storage to offload, edit, and stream anywhere.

High-capacity, wireless mobile storage designed to accompany professional photographers and videographers in the field to easily offload, edit and stream captured photos and high-definition videos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Forbidden errors 5 121
IIS Site Configuration Copy 2 70
.htaccess rewrite url with querystring problem 13 85
Help with a redirect in web.config file 8 25
This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now