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>


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

Original text of this message