Re: ora-06502 and ora-06512.

From: EdStevens <quetico_man_at_yahoo.com>
Date: 13 Feb 2006 06:13:28 -0800
Message-ID: <1139840008.309111.262210@o13g2000cwo.googlegroups.com>

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