Re: How to debug a stored procedure in oracle?

Well, I would use the client tool Oracle Procedure Builder where you can set breakpoints etc.

Which version you need, depends on your database version. So ask your Oracle support which one is supported against your RDBMS. The newest PB version is included in Developer R6.0 !

Hope this helps
Stephan

Johnson Chao wrote:

> Hello:
> Anyone can tell me how to debug a stored procedure in oracle?
>
> Can I setup breakpoint in the procedure? What tool I should use?
>
> Thanks.
>
> --
> Johnson Chao
> ctc Japan
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
------------------------------------
Stephan Witt
Munich

Phone: +49 (0)89 - 147399-40
Fax:   +49 (0)89 - 147399-39
------------------------------------