Re: Calling procedure
From: Dan Blum <tool_at_panix.com>
Date: Mon, 25 Aug 2008 20:31:03 +0000 (UTC)
Message-ID: <g8v4q6$lou$1@reader1.panix.com>
Date: Mon, 25 Aug 2008 20:31:03 +0000 (UTC)
Message-ID: <g8v4q6$lou$1@reader1.panix.com>
Mtek <mtek_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???
If we could see the CREATE PROCEDURE statement (just down to the IS) that would help. Also, is the procedure in the same schema the calling code is in?
-- _______________________________________________________________________ Dan Blum tool_at_panix.com "I wouldn't have believed it myself if I hadn't just made it up."Received on Mon Aug 25 2008 - 15:31:03 CDT