RE: ampersand problem

Well, for one thing, you have MOM instead of MON in the date format. Besides that, it might help if you describe what problem you are having.

At 12:10 AM 10/5/01 -0800, you wrote:

>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; /

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Regina Harter
  INET: rharter_at_emc-inc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).