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: '[EMAIL PROTECTED]'
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;
/
