Re: Problem with my Procedure, Please Help

create procedure myproc (a number ,b number ,c varchar2) as insert into table_name (x,y,z) values (a,b,c); commit;
end;

then call myproc passing 3 parameters
exec (100,200,'test');

Venkat

enclose
>create procedure myproc .....
>as
>insert into table_name (x,y,z) values ('&a','&b','&c');
>commit;
>end;
>this accepts input from me but does not insert them in the table.
>
Received on Mon May 25 1998 - 00:00:00 CDT