Re: procedures in dba studio

Can't help you there as I don't like DBA Studio. But I can help you in two other ways.

1. Log on in SQL*Plus and type the following at the SQL> command prompt:

alter procedure <proc_name> compile;

it will either compile successfully for indicate that errors exist. To view the errors and their associated line numbers type:

SHO ERR 2. SQL Server code migrated to PL/SQL is usually garbage. I strongly urge you to use what you have as a starting point and rewrite it to take advantage of (not sabotage) Oracle's shared pool.

Daniel Morgan

Peter K wrote:

> Hi,
> after autom. migration sqlserver -> oracle 8, i want to view and test some
> migrated stored procedures that have status invalid.
> i use dba-studio -> <db> -> schema -> <owner> -> procedures and i am
> connected as sysdba. On the right side i can see the source and buttons
> "compile" and "show errors". status is invalid but "show errors" is grayed.
> how can i modify, recompile and especially view errors ?
>
> regards
> peter
Received on Tue Jan 15 2002 - 09:13:11 CST