Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-06502 and ora-06512.
o wrote:
> 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;
Oracle version? Operating system?
Have you looked up the error messages on OTN or MetaLink? What did they say? Received on Mon Feb 13 2006 - 08:13:28 CST