Database Administration (MOSC)

MOSC Banner

simple problem with procedure.

edited Feb 20, 2010 2:10AM in Database Administration (MOSC) 15 commentsAnswered
Hi DBAs I have a question i really appreciate your fast response
when i create  very simple procedure via toad i receive below error while debugging :

CREATE OR REPLACE PROCEDURE test102
IS
BEGIN
    DBMS_OUTPUT.PUT_LINE('test1');

    DBMS_OUTPUT.PUT_LINE('test 2');
END;


error message:
ORA-29532:JAVA CALL TERMINATED BY UNCAUGHT JAVA EXCEPTION:
java.lang.ArithmeticException:/ by zero
ORA-06512:at "SYS.DBMS_JAVA",line 124
ORA-06512:at line 1

we have not patched database after it has became production.
do i need to have other permissions?
also i have read <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center