Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to enable native PL/SQL compilation in 9i Release 2 on Windows?

compilation enable native PL release sql Windows
0
Posted

How to enable native PL/SQL compilation in 9i Release 2 on Windows?

0 CommentsAdd a Comment

1 Answer

0

By Vladimir M. Zakharychev Native PL/SQL compilation (this link leads to OTN site, which needs registration to access – registration is free) is a new feature of Oracle9i Database. As such, it was not implemented in 9i Release 1 on Windows (this fact was accounted as a bug in 9iR1). Release 2 was said to support ncomping the PL/SQL on Windows, but in reality there’s a lot of things you need to do before you can compile your PL/SQL natively. Here are the steps necessary to make it work on Release 2 (9.2.0.1): • Create ORAPLS9.LIB from ORAPLS9.DLL. As of 9i Release 2 patch set 1 (9.2.0.2) and later, this step is no longer necessary, as ORAPLS9.LIB is supplied with this patchset. Those readers who have 9.2.0.2 or later patch set applied may skip this step. Amazingly, Oracle didn’t supply this library effectively preventing the code from being linked successfully. However, you can create this library yourself. Two tools are needed for this: Borland IMPDEF (availab

0 CommentsAdd a Comment
What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.