RE: Force an ora-600?

  • From: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
  • To: <sacrophyte@xxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Apr 2008 14:36:59 -0700

Charles Schultz wrote:

> ...
> I would like to force an ora-600.

Please see my blog entry on dbke_test:

http://oradeblog.blogspot.com/2007/10/unittest-command-in-oradebug.html

In short:

SQL> oradebug unit_test dbke_test dde_flow_kge_ora stupid_idiot 0 0

or

declare
v_bug exception;
pragma exception_init(v_bug,-600);
begin
raise v_bug;
end;
/

(Thanks to Jared for PL/SQL)

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net


--
//www.freelists.org/webpage/oracle-l


Other related posts: