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: '[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; /
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
