Re: Calling procedure

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

Yes, everything is compiled. It is something very funky I'm missing. Because I coded some calls to other procedures in the same fashion and such and no issues at all..... Received on Mon Aug 25 2008 - 16:07:34 CDT