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

From: Joe Sugden <jsugden_at_netmeg.net>
Date: 1999/11/22
Message-ID: <Qmh_3.1280$Eh5.78710_at_monger.newsread.com>#1/1

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 - 00:00:00 CET

This message: [ Message body ]
Next message: Jean Boulé: "Re: How do I know the line number in a stored procedure?"
Previous message: Van Messner: "Re: INIT.ORA - UTL_FILE_DIR parameter..."
Next in thread: Jean Boulé: "Re: How do I know the line number in a stored procedure?"
Reply: Jean Boulé: "Re: How do I know the line number in a stored procedure?"
Reply: rtproffitt_at_my-deja.com: "Re: How do I know the line number in a stored procedure?"
Maybe reply: Rachel Rainey: "Re: How do I know the line number in a stored procedure?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message