Re: Calling procedure
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 25 Aug 2008 23:49:54 +0200
Message-ID: <48B32902.7090607@gmail.com>
>
>
> 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
Date: Mon, 25 Aug 2008 23:49:54 +0200
Message-ID: <48B32902.7090607@gmail.com>
Mtek schrieb:
> 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
You have to pass *all* the parameters by calling the procedure which don't have defaults, haven't you?
Best regards
Maxim Received on Mon Aug 25 2008 - 16:49:54 CDT