Re: Calling procedure

Mtek <mtek_at_mtekusa.com> wrote:
> On Aug 25, 3:31 pm, t..._at_panix.com (Dan Blum) wrote:
> > 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???
> >
> > 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 t..._at_panix.com
> > "I wouldn't have believed it myself if I hadn't just made it up."

> Sorry,

> Actual procedure statement is below. and, it is not in the same
> schema, but I grated execute privileges as well as created a public
> synonym. I did try prefixing the schema name also:

> 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);

> CREATE OR REPLACE PROCEDURE CUSTOMER.INSERT_PORTFOLIO_ARR (
> p_user_id NUMBER,
> p_portfolio_id NUMBER DEFAULT NULL,
> p_line IN_STR_ARR,
> p_ticker IN_STR_ARR,
> p_price IN_STR_ARR,
> p_shares IN_STR_ARR,
> p_date IN_STR_ARR,
> p_comm IN_STR_ARR,
> p_action IN_STR_ARR,
> p_portfolio_name VARCHAR2 DEFAULT NULL,
> p_portfolio_des VARCHAR2 DEFAULT NULL,
> product VARCHAR2 DEFAULT NULL) IS

Are you sure that INSERT_PORTFOLIO_ARR compiles? If it has an error, that will result in the error you are seeing.

-- 
_______________________________________________________________________
Dan Blum					         tool_at_panix.com	
"I wouldn't have believed it myself if I hadn't just made it up."