Re: Mysterious

rajs, rajs_at_meghdoot.mastek.com wrote:
>
> Hi,
> I have noticed a curious behaviour. I have stored procedure on Oracle 7.3 Windows NT.
> The simplified script is as follows -
> PROCEDURE sp_dummy
> (ve_sales_cd IN varchar2, ve_stock_cd IN varchar2,ve_client_type IN varchar2, ve_dealer OUT varchar2) is
>
> ve_dealer_cd varchar2(3);
> n number(4);
> ve_found number(1);
> begin
> ve_dealer:= 'SDS';
> END;
>
> I call this procedure through Forms 4.5 (32-bit)
> The script in forms is as follows
> declare
> user_id varchar2(10) := 'KK';
> stock_Cd varchar2(10) := 'APCI';
> client_type varchar2(3) := 'ILT';
> ve_dealer char(3) :=' ';
> begin
> sp_dummy(user_id,stock_cd,client_Type,ve_dealer);
> message(ve_dealer);
> end;
>
> This gives me a value error, but the same script run through SQL*Plus gives the result SDS. Is this a problem normal ?
> I will be happy if somebody can help me out with this "Relatively Simple Procedure'.
>
> thanks
> Rajs

Hi Raj,

Declare the parameter ve_dealer as IN OUT instead of just OUT in the procedure sp_dummy. It might work. Just check this out. Received on Fri May 30 1997 - 00:00:00 CEST