Re: PL/SQL

From: <abalbekov_at_usa.net>
Date: Fri, 11 Dec 1998 19:09:19 GMT
Message-ID: <74rqkt$4bi$1@nnrp1.dejanews.com>

In article <01be2353$cc66cee0$44dbd8c1_at_AC7820BU120767.ac.com>, "Håkon Larsen" <hakon.larsen_at_c2i.net> wrote:
> How can I easily debug PL/SQL-code?
> (I'm not very experienced)
>
> Hope someone can give me a hint.
>
> hH
>

I would recommend SQL*Navigator. It allows to debug PL/SQL on the server side (set break points, see/modify variables and so on). Saves a lot of time.

Probably Oracle's Procedure Builder in it's latest version can do the same, I'm not sure. In previous versions it allowed client-side PL/SQL debugging with it's own, separate from server, PL/SQL engine. That client-side PL/SQL was an old, version 1.5 syntax.

Or you can just use plain SQL*Plus, set serveroutput on and dbms_output.put_line :)

Albert

--
Albert Balbekov, Senior Consultant
GRT Inc.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 11 1998 - 13:09:19 CST