PLS-00923 [message #229948] |
Tue, 10 April 2007 06:49 |
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 |
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
|
|
|