Re: Debugging scripts

From: Dan Statham <GreatDayDan_at_sbcglobal.net>
Date: Mon, 08 Mar 2004 17:41:17 GMT
Message-ID: <1f23c.1038$dW.234908774@newssvr11.news.prodigy.com>

Good Morning!

That was it!

My problem turned out to be case sensitivity. Some installations do not have a problem comparing mixed case, some do. The one that had trouble, did. So I changed the strings to upper case. Viola!

Thanks...Dan'l

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:gq8YCbBGXULARxs3_at_peterfinnigan.demon.co.uk...
> Hi
>
> Have a look at dbms_output. For dbms_output you should do
>
> SQL> set serveroutput on size 1000000
>
> in sqlplus first and then in your pl/sql add lines of the format:
>
> dbms_output.put_line('This is a trace message');
> dbms_output.put_line('This is a value '||v_counter);
>
> hth
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:pete_at_petefinnigan.com
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details. Received on Mon Mar 08 2004 - 11:41:17 CST