Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with my Procedure, Please Help

Re: Problem with my Procedure, Please Help

From: <andreas.prusch_at_sintec.de>
Date: 1998/05/25
Message-ID: <6kc1um$3gf$1@nnrp1.dejanews.com>#1/1

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US