Re: Calling procedure

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