Re: Problem with my Procedure, Please Help

Í have tested the following in SQL-Plus. It works fine:

• Begin of SQL-Plus Commands accept i prompt 'Enter Var 1:' select * from store where store_key = &&i;

create or replace
procedure ins is
begin
  insert into store (store_key) values (&&i); end;
/
execute ins;

select * from store where store_key = &&i; -- End of SQL-Plus Commands

I hope that will help you.

Andreas Prusch

In article <01bd86c7$40c7ed20$35a185ce_at_default>,   "G Vaidhyanathan" <root1_at_sprintmail.com> wrote:
>
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 00:00:00 CDT