Re: debugging using procedure builder

In article <5bo9a2$238_at_madeline.INS.CWRU.Edu>, dw724_at_cleveland.Freenet.Edu (Dennis M. Hancy) wrote:
>
>I have a procedure (PL/SQL) that will read data from a text file into
>an Oracle table. After 107 records, it stops with an error, but I can't
>tell from the error code what the problem is. I could use the Debug
>feature but I didn't want to step through the loop 107 times. Does
>anyone have a suggestion as to how I might be able to debug the procedure?

Try putting dbms_output.* code at strategic points... Check the PL/SQL User's Guide for the package 'DBMS_OUTPUT' in the index.

--
-- Curtis.Hanson_at_UAlberta.ca (a Motif apprentice)
-- Oracle enabling the Department of Physical Plant
--

--
-- Curtis.Hanson_at_UAlberta.ca (a Motif apprentice)
-- Oracle enabling the Department of Physical Plant
--