Thanks Jherrick

I swithed back into default non-native(interpred) mode na all is working
well.



-----Mensagem original-----
De: jherrick [mailto:oracledba-ezmlmshield-x593303.[Email address protected]
Enviada em: quinta-feira, 29 de março de 2007 10:51
Para: LazyDBA Discussion
Assunto: Re: Errors compiling procedures in oracle 10g



Off the top of my head I would say it can't find the Visual C++ compiler
software in order to compile the PL/SQL into 'native' i.e. executable
format. If you really don't have a compiler then you should switch back into
the default non-native(interpreted) mode. Either remove the
'plsql_compiler_flags' or set it to 'INTERPRETED'

Cheers

Quoting Solange Januzi Tanuz Maia
<oracledba-ezmlmshield-x64217839.[Email address protected]

> Hi everybody
>
> I have faced some problems in compiling procedures after migrating
> from oracle 8 to oracle 10g. When trying to compile a sample
> procedure, the compiler shows these error
> messages:
>
> SQL> Alter PROCEDURE SP.BUSCA_COLETAS COMPILE;
>
> Warning: Procedure altered with compilation errors.
>
> SQL> show errors
> Errors for PROCEDURE SP.BUSCA_COLETAS:
>
> LINE/COL ERROR
> -------- -----------------------------------------------------------------
> 0/0 PLS-00923: native compilation failed: Visual Studio not
> found::Could not open registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\VISUALSTUDIO\7.0\SETUP:No
> error
>




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page