Igor, Thanks for the clarification. You are correct. There is simply no longer a need to set the Oracle 9i init parameters pointing to the c compiler and the dependence on the make utility has been eliminated. In short, there has to be a c compiler installed but in 10G NCOMP this, as you stated, should be transparent to the DBA. Ellis -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Igor Neyman Sent: Wednesday, July 28, 2004 12:54 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Anyone implented compiled PL/SQL? Regarding external C compiler. It's still required. Only it's done "behind the scene". When you are creating plsql code in "native" mode, Oracle is smart enough to find C compiler and use it (i.e.: on Win platform it looks into registry for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.0\...), so no "additional" steps required. If C compiler isn't installed, you'll be getting appropriate error message. Igor Neyman, OCP DBA ineyman@xxxxxxxxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ellis R. Miller Sent: Wednesday, July 28, 2004 11:16 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Anyone implented compiled PL/SQL? ..................................................... ..................................................... ..................................................... On a final note, the Oracle 10G NCOMP is much easier to configure: do not require an external c compiler, such as gcc, or make utility. In essence, only have to set one parameter. Here are some really basic notes on NCOMP in Oracle 10G: Which Oracle parameters are relevant to native compilation? --------------------------------------------------------------- 1. plsql_native_library_dir -- create directory to hold shared libraries 2. plsql_native_library_subdir_count -- optional 3. plsql_code_type -- set at the database level or session ..................................................... ..................................................... ..................................................... ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------