The obvious questions are:

1. Do you have Visual Studio installed on the Oracle10 server?
2. Is the directory structure for Visual Studio exactly the same on this server as on the Oracle8 server?
3. Does this registry key exist on the Oracle10 server?

-----Original Message-----
From: Solange Januzi Tanuz Maia [mailto:oracledba-ezmlmshield-x64217839.[Email address protected]
Sent: Thursday, March 29, 2007 9:45 AM
To: LazyDBA Discussion
Subject: Errors compiling procedures in oracle 10g

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]




---------------------------------------------------------------------
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



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page