Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error (ASP.NET Framework 2.0)
ORA-06502: PL/SQL: numeric or value error [message #572823] Tue, 18 December 2012 00:30 Go to next message
Messages: 1
Registered: December 2012
Location: Mumbai
Junior Member
create or replace package pckname is
Procedure VALIDATE_USER(p out credentials.pc%TYPE,
u in credentials.uc%TYPE,
c in credentials.sc%TYPE);
end pckname;

I m getting error at line 1 and line 8:
Please any one can help me out with this.
Re: ORA-06502: PL/SQL: numeric or value error [message #572833 is a reply to message #572823] Tue, 18 December 2012 01:13 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

As there is no line 8 in what you posted no one can help you.
Use SQL*Plus and copy and paste your session, the WHOLE session.

Previous Topic: Redo log generated in Materalized view
Next Topic: ORA-03113 end-of-file on communication channel
Goto Forum:

Current Time: Sun Aug 20 19:54:06 CDT 2017

Total time taken to generate the page: 0.00919 seconds