Pls-00923
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Pls-00923

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Pls-00923

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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have the compiler installed on the machine - which you do not (pretty much like it tells you really)

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by davey23uk
    have the compiler installed on the machine - which you do not (pretty much like it tells you really)
    yes i don't have c-complier installed ,
    where i can find c-complier?
    how to configure c-complier?
    where to configure c-complier?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how about reading the message and getting what it says you dont have (HINT: Visual Studio)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width