PL/SQL (MOSC)

MOSC Banner

oracle error line number into stored procedures

edited Nov 13, 2014 10:03AM in PL/SQL (MOSC) 5 commentsAnswered


hello,

I've a package with a lot of stored procedures in it and I've to execute it on Oracle Client 11... to not insert messages after any line of code to intercept the errors ... exists there any oracle error msg that indicates the line (on the st.prcd)  or the name of the st.Procedure where the error succeded in case of Exception (appart from SQLCODE and SQLERRM from )?

------------------------------------------

st. prcd ...

.....

.....

....

exception
    when others then
      Rollback;
      paMinorCode:=SQLCODE;
      paMinorMsg:=SQLERRM;
      return;

end;

-------------------------------------------

thank you

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