como depurar um script pl/sql

[Marcos Augusto 0]

Bom dia, pessoal estou querendo depurar um script que vai virar um pracedure e nao consigo no pl/sql alguem sabe onde eu consigo um exemplo ?o briogado Marcos

[MonTiLLa 1]

Opa Marcos,

 

Uma forma de depurar um programa pl-sql seria com o pacote dbms como no exemplo abaixo:

 

begin for deleta in (select table_name, 'DROP TABLE '||table_name||' cascade constraints' AS dropar from user_tables) loop
      BEGIN dbms_output.put_line('DROP TABLE '||deleta.table_name||' cascade constraints;');
      EXCEPTION WHEN OTHERS THEN
        dbms_output.put_line('Erro ao tentar dropar a tabela: '||deleta.table_name);
      END;
   end loop;
end;
/

 

Porém existem programas já criados para esse intuito.

 

http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif

[bruno-d2 0]

Só para completar e tentar ajudar mais.Para usar o 'dbms_output.put_line' sugerido pelo MonTiLLa, você precisa ligar a diretiva:SERVEROUTPUT, fica assim:SET SERVEROUTPUT ONE existe um software bom da oracle.. o Oracle SQL Developer ou o SQL Navigator.Existem vários.. mas como tbm sou iniciante, rsvai ai só esses..flw

[Motta 645]

Achei esta dica uma vez que permitiria debugar via sql plus mas nunca tive nem tempo nem necessidade de tentar usa-la.

Se funcionar para alguém peço que poste pois pode ajudar à comunidade.

 

_________________

Using Oradebug Utility

ORADEBUG utility is a debugging tool that sends debug commands through SQL*Plus to an Oracle process. It is primarily for use by developers and Oracle Support Services personnel. Use this utility only when instructed to do so by Oracle Support Services. You must have database administrator privileges to use ORADEBUG utility.

To start ORADEBUG utility:

1. Start SQL*Plus from the command prompt:

2. C:\> sqlplus / NOLOG

3.

2. Connect to Oracle9i database as SYSDBA:

3. SQL> CONNECT / AS SYSDBA

4.

3. Enter the following at the SQL*Plus prompt:

4. SQL> ORADEBUG

5.

ORADEBUG utility runs and prompts you for parameters. To obtain a list of these parameters, enter the following at the SQL*Plus prompt:

SQL> ORADEBUG HELP

 

Output from most debug commands is written to a trace file. Trace files are created in the directory specified by initialization parameters BACKGROUND_DUMP_DEST and USER_DUMP_DEST. By default, these parameters are set to ORACLE_BASE\ADMIN\db_name\bdump and ORACLE_BASE\ADMIN\db_name\udump, respectively. To find the location of your trace file, enter the following at the SQL*Plus prompt:

SQL> ORADEBUG TRACEFILE_NAME

 

If output from a debug command produces more than one line of output, then the result is sent to a trace file, and a message indicating that the command has completed is relayed to SQL*Plus. If output from a debug command produces only one line of output, then the output is relayed directly to SQL*Plus.

 

 

Reference:

 

Oracle DBA Guide

----------------------------------------------