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
>



Oracle LazyDBA home page