Re: Calling procedure
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