Re: passing in arguments to oracle procedure

On Wed, 20 Apr 2005 23:08:28 -0700, DA Morgan <damorgan_at_x.washington.edu> wrote:

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

Also add 'AND type = 'PACKAGE' to the WHERE-clause, otherwise text from the package will by mixed which those from the package body.

Jaap. Received on Fri Apr 22 2005 - 14:48:17 CDT