OraFAQ Forum: SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error (ASP.NET Framework 2.0)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-06502: PL/SQL: numeric or value error [message #572823]

Tue, 18 December 2012 00:30

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.

Report message to a moderator

Re: ORA-06502: PL/SQL: numeric or value error [message #572833 is a reply to message #572823]

Tue, 18 December 2012 01:13

Michel Cadot
Messages: 54129
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

Report message to a moderator

Previous Topic:	Redo log generated in Materalized view
Next Topic:	Explain plan help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 23:00:51 CDT 2013

Total time taken to generate the page: 0.10334 seconds