Discussion:
ora-20315 - cant find anything on this error.
rob oraclewizard.com
2018-07-30 17:57:21 UTC
Permalink
Has anyone seen ORA-20315, It is being raised when a commit is issued. I can't find any documentation on this error. Any ideas. Thanks, -Rob
Lyall Barbour
2018-07-30 18:16:29 UTC
Permalink
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Custom error?&nbsp; User-defined?&nbsp; are there other messages with it? <div>&nbsp; <div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"> <div style="margin:0 0 10px 0;"><b>Sent:</b>&nbsp;Monday, July 30, 2018 at 1:57 PM<br/> <b>From:</b>&nbsp;&quot;rob oraclewizard.com&quot; &lt;***@oraclewizard.com&gt;<br/> <b>To:</b>&nbsp;Oracle-L &lt;oracle-***@freelists.org&gt;<br/>
<b>Subject:</b>&nbsp;ora-20315 - cant find anything on this error.</div>

<div name="quoted-content">
<p>Has anyone seen ORA-20315, It is being raised when a commit is issued. I can&#39;t find any documentation on this error. Any ideas. Thanks, -Rob</p>
</div>
</div>
</div>
</div></div></body></html>
--
http://www.freelists.org/webpage/oracle-l
Rumpi Gravenstein
2018-07-30 18:16:40 UTC
Permalink
That's in the user defined error range.

Defining Your Own Error Messages: Procedure RAISE_APPLICATION_ERROR

The procedure RAISE_APPLICATION_ERROR lets you issue user-defined ORA- error
messages from stored subprograms. That way, you can report errors to your
application and avoid returning unhandled exceptions.

To call RAISE_APPLICATION_ERROR, use the syntax

raise_application_error(error_number, message[, {TRUE | FALSE}]);

where error_number is a negative integer in the range -20000 .. -20999 a
Post by rob oraclewizard.com
Has anyone seen ORA-20315, It is being raised when a commit is issued. I
can't find any documentation on this error. Any ideas. Thanks, -Rob
--
Rumpi Gravenstein
rob oraclewizard.com
2018-07-30 18:48:02 UTC
Permalink
Jonathan, that makes sense. it was hidden in a package deep in the bowels of the application. thanks. Are you planning on being at POUG or BGOUG this year? -Rob
It's an error number in the range reserved for raise_application_error (-20000 to -20999), and some Oracle-supplied code uses values in the range; but it doesn't seem to appear in any of the scripts (.sql and /plb) in $ORACLE_HOME/rdbms/admin so it's probably a home-grown option.
You could search dba_source for "raise_application_error" or "-20315".
Regards
Jonathan Lewis
________________________________________
Sent: 30 July 2018 18:57
To: Oracle-L
Subject: ora-20315 - cant find anything on this error.
Has anyone seen ORA-20315, It is being raised when a commit is issued. I can't find any documentation on this error. Any ideas. Thanks, -Rob
--
http://www.freelists.org/webpage/oracle-l

Loading...