Re: error PLS-00923 while native compilation

From: Paweł Poradzisz <pawelp_at_webpl.com>
Date: Wed, 12 Mar 2008 16:12:06 +0100
Message-ID: <fr8rum$74j$1@atlantis.news.neostrada.pl>

Użytkownik "Shakespeare" <whatsin_at_xs4all.nl> napisał w wiadomości news:47d7e17d$0$14353$e4fe514c_at_news.xs4all.nl...
>
> "Paweł Poradzisz" <pawelp_at_webpl.com> schreef in bericht
> news:fr8m7t$2uv$1_at_nemesis.news.neostrada.pl...
>>
>> Użytkownik "Shakespeare" <whatsin_at_xs4all.nl> napisał w wiadomości
>> news:47d7c147$0$14354$e4fe514c_at_news.xs4all.nl...
>>>
>>> "Paweł Poradzisz" <radny_at_tenbit.pl> schreef in bericht
>>> news:fr68ed$b30$1_at_nemesis.news.neostrada.pl...
>>>>I trying compile in native mode my objects in database (oracle 10.2)
>>>>but i have an error:
>>>>
>>>> On line: 0
>>>> PLS-00923: niepowodzenie rodzimej kompilacji: Microsoft SDK not
>>>> found::Could not open registry key HKEY_USERS or
>>>> HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\MicrosoftSDK\InstalledSDKsNo error
>>>>
>>>> .I have installed SDK on my server.Anyone can help me?
>>>>
>>>
>>> Is this registry key there?
>>>
>>> Shakespeare
>>>
>>>
>>
>> ---- Original Message -----
>> From: "Shakespeare" <whatsin_at_xs4all.nl>
>> Newsgroups: comp.databases.oracle.server
>> Sent: Wednesday, March 12, 2008 12:40 PM
>> Subject: Re: error PLS-00923 while native compilation
>>
>>
>>>
>>> "Paweł Poradzisz" <radny_at_tenbit.pl> schreef in bericht
>>> news:fr68ed$b30$1_at_nemesis.news.neostrada.pl...
>>>>I trying compile in native mode my objects in database (oracle 10.2)
>>>>but i have an error:
>>>>
>>>> On line: 0
>>>> PLS-00923: niepowodzenie rodzimej kompilacji: Microsoft SDK not
>>>> found::Could not open registry key HKEY_USERS or
>>>> HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\MicrosoftSDK\InstalledSDKsNo error
>>>>
>>>> .I have installed SDK on my server.Anyone can help me?
>>>>
>>>
>>> Is this registry key there?
>>>
>>> Shakespeare
>>>
>>>
>> No , it isn't.
>>
>> On one of serwers Microsoft Visual Studio 2003 are installed
>> and on this server native compilation is enable.
>>
>> Byt we are working on client-server system where Oracle server ar running
>> on
>> seperated machine.
>> This server is Microsoft Windows Server 2003 R2 Standard x64 Edition with
>> -.Net 1.1
>> -.Net 1.1 SDK
>> -.Net 2.0
>> -.Net 2.0 SDK
>>
>> How to compile my procedures in native mode?What i need?
>>
>> Thanks for help.
>> Paulo
>>
>>
>
> I would think you have to enable native compilation at the database
> server, since the compilation process is done at the server.
>
> Shakespeare
>

Shakespeare this is what i have done:

alter system set plsql_compiler_flags = 'NATIVE';

and next

compile package in Toad

Finally i see message :

PACKAGE REPORTS
On line: 0
PLS-00923: niepowodzenie rodzimej kompilacji: Microsoft SDK not found::Could not open registry key HKEY_USERS or
HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\MicrosoftSDK\InstalledSDKsNo error

Thx Received on Wed Mar 12 2008 - 10:12:06 CDT

Original text of this message