Re: Calling procedure

From: <rogergorden_at_....gmail.com>
Date: Tue, 26 Aug 2008 11:30:10 -0700 (PDT)
Message-ID: <2e6f9923-3905-40f8-8fb8-ff79656f4871@r15g2000prh.googlegroups.com>


On Aug 25, 4:20 pm, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> I'm trying to call a procedure like this:
>
> INSERT_PORTFOLIO_ARR (
>     p_user_id        => p_customer_id,
>     p_portfolio_id   => p_portfolio_id,
>     p_ticker         => v_ticker_tab,
>     p_action         => v_action_tab);
>
> There are a bunch more parameters, but I only have to pass those.  I
> get this error when trying to compile the code:
>
> 84/7     PL/SQL: Statement ignored
> 84/16    PLS-00302: component 'INSERT_PORTFOLIO_ARR' must be declared
>
> Any thoughts?  Does this have to be a packaged procedure???

Just a small issue here:

When executing a procedure the proper way to do it is like this:

execute INSERT_PORTFOLIO_ARR (

     p_user_id        => p_customer_id,
     p_portfolio_id   => p_portfolio_id,
     p_ticker         => v_ticker_tab,
     p_action         => v_action_tab);

Unless you're inside a PL/SQL block, in which case your way is correct.

Do you get this when you run it from sqlplus??

Roger Gorden Received on Tue Aug 26 2008 - 13:30:10 CDT

Original text of this message