Home » RDBMS Server » Server Administration » PLS-00923
PLS-00923 [message #229948] Tue, 10 April 2007 06:49 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
In Oracle 10g
SQL> ALTER SESSION SET PLSQL_CODE_TYPE='NATIVE';

Session altered.

SQL> ALTER PROCEDURE test_speed COMPILE;

Warning: Procedure altered with compilation errors.

SQL> show errors
Errors for PROCEDURE TEST_SPEED:

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

what i have to do to test plsql_code_type='NATIVE' ?
Re: PLS-00923 [message #229960 is a reply to message #229948] Tue, 10 April 2007 07:22 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Are you using VS 2005 or VS 2003?

VS 2005 is not supporting pl/sql native compilation as far as I know...Use VS 2003
Previous Topic: Installation
Next Topic: 10.2.0.1 install & patches
Goto Forum:
  


Current Time: Thu Sep 19 23:34:08 CDT 2024