Home » SQL & PL/SQL » SQL & PL/SQL » Migrating from Oracle 7 to Oracle 8i
Migrating from Oracle 7 to Oracle 8i [message #1797] Thu, 30 May 2002 13:09 Go to next message
Lynn Haynes
Messages: 1
Registered: May 2002
Junior Member
We are upgrading from Oracle 7 to 8i, and have pl/sql code is failing with the following:

ORA-6502: PL/SQL: numeric or value error: character to number conversion error at line 46...

It is documented (Doc iD: NOTE:130132.1) that Oracle 7 will do an implicit conversion, while Oracle 8 will not, and will raise an exception.

My question is, we have THOUSANDS of lines of pl/sql code. Is there some utility someone knows of that will help me sift through the code to identify these problems? It will take MONTHS to test the whole repository of pl/sql code!

Report message to a moderator

Re: Migrating from Oracle 7 to Oracle 8i [message #1800 is a reply to message #1797] Thu, 30 May 2002 21:39 Go to previous message
hemamalini r.
Messages: 1
Registered: May 2002
Junior Member
if you have thousands of lines of plsql code,oracle will raise pre-defined exception or manually you raise
user-defined exceptions.

Report message to a moderator

Previous Topic: Can anyone help me ?
Next Topic: ALTER SEQUENCE in a procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 06:04:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.