Problem with my Procedure, Please Help

Hello :

How do I get the values (from command line) for the fields in my table and insert them in the table?
All this needs to be done in one procedure.

I tried something like

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.

I also tried inserting

Execute procedurename;

after the insert statement but for no use.

thanks in advance

-ganesh Received on Mon May 25 1998 - 00:00:00 CDT