Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ora-06502 and ora-06512.

ora-06502 and ora-06512.

From: o <new2unix_at_gmail.com>
Date: 12 Feb 2006 23:37:28 -0800
Message-ID: <1139816248.107279.58230@z14g2000cwz.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US