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

From: Jean Boul� <jboule_at_capitale.qc.ca>
Date: 1999/11/22
Message-ID: <Foh_3.3107$63.57979_at_news.globetrotter.net>#1/1

Try the table user_source

Name                            Null?    Type
------------------------------- -------- ----
NAME                            NOT NULL VARCHAR2(30)
TYPE                                     VARCHAR2(12)
LINE                            NOT NULL NUMBER
TEXT                                     VARCHAR2(4000)

Jean Boul�

Joe Sugden a �crit dans le message ...
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: Vidya: "Backup/Recover datafile doubts..Please help"
Previous message: Joe Sugden: "How do I know the line number in a stored procedure?"
In reply to: Joe Sugden: "How do I know the line number in a stored procedure?"
Next in thread: rtproffitt_at_my-deja.com: "Re: How do I know the line number in a stored procedure?"
Reply: Geoffrey Stewart: "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