Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How do I know the line number in a stored procedure?

How do I know the line number in a stored procedure?

From: Joe Sugden <jsugden_at_netmeg.net>
Date: Mon, 22 Nov 1999 20:06:08 GMT
Message-ID: <Qmh_3.1280$Eh5.78710@monger.newsread.com> 





I have been creating some lengthy stored procedures lately, and using
Enterprise Manager to help de-bug them.  The problem for me is finding the
right line when there is an error.  I know there is a V$ view that has the
line numbers and corresponding code, but I don't remember which one that is.



Does anyone have any recommendations?  How do you deal with this?


Received on Mon Nov 22 1999 - 14:06:08 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US