RE: ampersand problem

From: Swapna_Chinnagangannagari <Swapna_Chinnagangannagari_at_satyam.com>
Date: Fri, 05 Oct 2001 00:13:36 -0700
Message-ID: <F001.003A2EE0.20011005001017@fatcity.com>

sorri i have pasted the wrong one
here is the correct on

declare
code number(3):=0;
edate date;
begin
code:=111;
edate:=to_date('01-jan-2001','dd-mom-yyyy'); dbms_output.put_line('actual data '||code ||','||edate); @abc code edate
dbms_output.put_line('hello');
end;
/

       

abc.sql

---

declare
my_code number(3);
my_date date;
begin
my_code:=&1;
my_date:='&2';
dbms_output.put_line('date in abc '||my_code ||','||my_date); end;
/

-----Original Message-----

From:   Swapna_Chinnagangannagari 
Sent:   Friday, October 05, 2001 12:27 PM
To:     'ORACLE-L_at_fatcity.com'

Subject:        ampersand problem

Why is this code not working for me

declare
code number(3):=0;
edate date;
begin
code:=111;
edate:=to_date('01-01-2001','dd-mm-yyyy'); dbms_output.put_line('actual data '||code ||','||edate); @abc code edate
dbms_output.put_line('hello');
end;
/

       

abc.sql

---

declare
my_code number(3);
my_number number(3);
begin
my_code:=&1;
my_number:='&2';
dbms_output.put_line('data in abc '||my_code ||','||my_number); end;
/
Received on Fri Oct 05 2001 - 02:13:36 CDT