Re: passing in arguments to oracle procedure

ginkim_at_gmail.com wrote:

> 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?

1. What Oracle version?
2. What is an asp file?
3. What is the definition of your "cursor"?
4. The fact that you don't know the internals of a package does not mean you can't read them.

    SELECT text
    FROM all_source
    WHERE owner = <owner_name>
    AND name = <package_name>
    ORDER BY line;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)