Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ora-06502 and ora-06512.
who can tell me what is wrong with the follwoing code.
i am getting ora-06502 and ora-06512.
CREATE OR REPLACE procedure add_hw_partition is
P_MaxValue varchar2(30):= to_char(trunc(sysdate -1),'SYYYY-MM-DD
HH24:MI:SS');
begin
dbms_output.put_line ((to_date((||P_MaxValue||),'SYYYY-MM-DD
HH24:MI:SS','NLS_CALENDAR=GREGORIAN')));
end;
Received on Mon Feb 13 2006 - 01:37:28 CST