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
ric2959
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: 59087
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.

Regards
Michel
Previous Topic: Redo log generated in Materalized view
Next Topic: Explain plan help
Goto Forum:
  


Current Time: Tue Sep 16 19:29:01 CDT 2014

Total time taken to generate the page: 0.08529 seconds