Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!newsfeed01.sul.t-online.de!t-online.de!solnet.ch!solnet.ch!news2.euro.net!postnews1.euro.net!postnews2.euro.net!news.wanadoo.nl!not-for-mail
From: Jaap W. van Dijk <j.w.vandijk.removethis@hetnet.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: passing in arguments to oracle procedure
Date: Fri, 22 Apr 2005 21:48:17 +0200
Message-ID: <75li61ho0s5hjejsmqucl92paicrfc6jnt@4ax.com>
References: <1114033411.880899.182400@l41g2000cwc.googlegroups.com> <1114063473.457894@yasure>
X-Newsreader: Forte Free Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 39
Organization: Wanadoo
NNTP-Posting-Date: 22 Apr 2005 19:46:39 GMT
NNTP-Posting-Host: p0123.nas3-asd6.dial.wanadoo.nl
X-Trace: 1114199199 dr1.euro.net 12002 62.234.216.123:1112
X-Complaints-To: abuse@wanadoo.nl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241037

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

>ginkim@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.