tags:

views:

73

answers:

1
Q: 

Regarding ORA 21000

Hi,

I am struggling with an ORA 21000 which says ORA-21000: error number argument to raise_application_error of 3739 is out of range.

This error is coming intermittently. I am not sure why this is occurring. This worked absolutely fine earlier, but after migrating to Linux from Solaris, this error has suddenly come up. Googling it didn't help. Please help.

Thanks in Advance.

A: 

RAISE_APPLICATION_ERROR is a method by which an application can raise a custom error in Oracle, which is why there will be no documentation about your error message.

This procedure accepts an error number argument, which must be in the range -20000 to -20999. Looks like your application is trying to raise 3739 which is not allowed.

This is a defect in your application.

Jeffrey Kemp  2010-05-27 07:02:12
Yes, but I have searched everywhere in my application and this error code 3739 is nowhere to be found. Any reason why it has started to show up suddenly? And I did not find anything related to ORA 3739...
SidCool  2010-05-27 08:03:23
You will have to trace it back to its source somehow. Examine all calls to `RAISE_APPLICATION_ERROR` in your code, perhaps the error code is being passed via a variable (although, hopefully, it is encoded in a constant somewhere).
Jeffrey Kemp  2010-05-27 10:51:33

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL