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 -> Re: How to debug the PL/SQL block?

Re: How to debug the PL/SQL block?

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 28 Dec 1998 16:31:53 -0500
Message-ID: <iRSh2.96$uV6.388@news6.ispnews.com>


Yes depending on what kind of debugging you wish to do. You can place dbms_ouput.put_line statements in your procedure to check the values of variables, or to see how far you've got in the procedure execution. When you execute the procedure in SQL+ you can look at these results.

Van

Huang Weidong wrote in message <36833A16.5B3A_at_pacific.net.sg>...
>I am new to oracle. Is it possible to debug the PL/SQL block in
>SQLPLUS? Or I need to use other tools to debug the block? And how?
>
>Thank in advance.
>
>weidong
Received on Mon Dec 28 1998 - 15:31:53 CST

Original text of this message

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