Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> passing in arguments to oracle procedure

passing in arguments to oracle procedure

From: <ginkim_at_gmail.com>
Date: 20 Apr 2005 14:43:31 -0700
Message-ID: <1114033411.880899.182400@l41g2000cwc.googlegroups.com>


Hi All,

I am trying to call a procedure but I am stuck with passing in an argument. The procedure looks like this:

CREATE OR REPLACE procedure P_Orders_Report(order_statistics_cursor in out order_statistics_package.order_statistics_type, startdate in varchar2, enddate in varchar2, ID in varchar2)

I'm trying to do this from an asp file. Since the first argument which is a cursor is "in out", I guess I'm supposed to declare it first so that I can pass it into the procedure. Since I did not create the procedure, I don't know what
order_statistics_package.order_statistics_type is about.

Does anyone know how I can declare the cursor and call the procedure from an asp file? Received on Wed Apr 20 2005 - 16:43:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US