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

My oracle parameters concerning to plsql are:

plsql_ccflags TRUE
plsql_code_type NATIVE TRUE
plsql_compiler_flags NATIVE, NON_DEBUG TRUE
plsql_debug FALSE TRUE
plsql_native_library_dir D:\PLSQL_NATIVE TRUE
plsql_native_library_subdir_co 0 TRUE
plsql_optimize_level 2 TRUE
plsql_v2_compatibility FALSE TRUE
plsql_warnings DISABLE:ALL TRUE


What is wrong? Any help is really appreciated.


Solange Januzi
Suporte Oracle - Infra-estrutura de Informática
Cia de Fiação e Tecelagem Cedro Cachoeira
( (31) 3235-5291
* [Email address protected] <mailto:[Email address protected]



Oracle LazyDBA home page