Oracle error log file

Yury Litvinov picture Yury Litvinov · Jul 8, 2011 · Viewed 8.5k times · Source

I'm running following block in Oracle (what does it do is not so important)

BEGIN
  SDO_RDF_INFERENCE.CREATE_RULES_INDEX(
    'my_index',
    SDO_RDF_Models('my_model'),
    SDO_RDF_Rulebases('RDFS'));
END;

and getting following error:

ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException
ORA-06512: at "MDSYS.RDF_APIS_USER", line 7
ORA-06512: at "MDSYS.RDF_APIS_USER", line 9
ORA-06512: at "MDSYS.RDF_APIS", line 477
ORA-06512: at line 2
29532. 00000 -  "Java call terminated by uncaught Java exception: %s"
*Cause:    A Java exception or error was signaled and could not be
           resolved by the Java code.
*Action:   Modify Java code, if this behavior is not intended.

Question: how can I access Oracle error log or something to get full stack trace or any other information about exception.

Answer

Arthur Frankel picture Arthur Frankel · Jul 8, 2011

This doesn't answer the question on how to see more info in the log, but you may want to look at this for some possible reasons for the error. Usually happens because you have not been granted permission to the Oracle object you are trying to access.