Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to debug the PL/SQL block?
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
![]() |
![]() |