Calling procedure
From: Mtek <mtek_at_mtekusa.com>
Date: Mon, 25 Aug 2008 13:20:46 -0700 (PDT)
Message-ID: <aa95d684-ce45-482f-836c-3e3e8ffb1ac4@y21g2000hsf.googlegroups.com>
Date: Mon, 25 Aug 2008 13:20:46 -0700 (PDT)
Message-ID: <aa95d684-ce45-482f-836c-3e3e8ffb1ac4@y21g2000hsf.googlegroups.com>
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??? Received on Mon Aug 25 2008 - 15:20:46 CDT