How does PL/SQL native compillation work?

From: Alexander Miroshnikov <alexander_miroshnikov_at_hotmail.com>
Date: 7 Apr 2003 08:02:19 -0700
Message-ID: <83192647.0304070702.566dbfe9@posting.google.com>

Documentation says that in order to create a natively compiled stored procedure Oracle generates C code correspondent to the PL/SQL code of the stored procedure. This code is then compiled and linked into a shared library. This shared library is then loaded and executed whenever the correspondent PL/SQL procedure is executed.

I created a couple of examples and noticed that the C code being generated during native compilation does not implement logic of the corespondent PL/SQL routine. It seems to consist of code required for instantiating PL/SQL units. Has anyone done any research on this subject yet? Could you explain how this stuff works?

Many Thanks,
Alex Received on Mon Apr 07 2003 - 10:02:19 CDT