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: 64967
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: Explain plan help
Goto Forum:

Current Time: Wed Jun 28 12:42:48 CDT 2017

Total time taken to generate the page: 0.07958 seconds