Skip to Content
0
Former Member
Jun 23, 2015 at 12:35 PM

stored procedure with out put parameters

15 Views

create type ANJALI.PRODUCT1 As table(

ProductID varchar(10),ProductName varchar(50),

color varchar(30)

);

create procedure ANJALI.USPCOLOR(in p_color varchar(50),out p_tab "ANJALI"."PRODUCT1" )

As

Begin

p_tab:=select ProductName,color from ANJALI.PRODUCT1

where color=:p_color;

end;

the error in this plz rectify this error