Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL To Pro*C Convertor
PL/SQL To Pro*C Convertor [message #49211] Thu, 27 January 2005 00:16 Go to next message
bhagwan
Messages: 86
Registered: September 2004
Member
Hi,
Is there any freeware available for converting PL/SQL programs to Pro*C ?

Regards,
Pankaj

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49217 is a reply to message #49211] Thu, 27 January 2005 14:04 Go to previous messageGo to next message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
The Native Compilation option in 9i?

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49221 is a reply to message #49217] Thu, 27 January 2005 20:54 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Do you have any experience with it ?
Is it substantially faster ?
Any disadvantages in maintenance ?

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49226 is a reply to message #49221] Fri, 28 January 2005 00:09 Go to previous messageGo to next message
kworld
Messages: 23
Registered: February 2003
Junior Member
what's your means?
convert pl/sql to pro*c
or auto make file pro*c that include call some pl/sql?
i once try write the secoder.
but can you tell me what you wanna do in detail ?

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49228 is a reply to message #49226] Fri, 28 January 2005 02:05 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
No, I meant it in reply to William's post, regarding native compilation of PL/SQL
(Bit Off Topic maybe)

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49233 is a reply to message #49221] Sat, 29 January 2005 05:44 Go to previous messageGo to next message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
No, sadly I have not yet worked at a client site where the DBA could be bothered to set this up, and it has only recently become available for my home plaform (same goes for Java). I need to upgrade a lot of stuff before I can try it at home.

From what I read, recompilation takes around twice as long under 9i, and for best results you should make everything native-compiled to avoid some switching overhead, including SYS packages. Performance should be the same or better, depending on how computationally intensive the code is.

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49234 is a reply to message #49221] Sat, 29 January 2005 11:24 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
I have tried to use native compilation unsuccesfully in Oracle 9.2.0.1.0 running on Windows XP Home Edition. It is a known bug that in the initial release of 9i, there was a missing file and other problems that prevented it from working without extensive workarounds that I was never able to get to work. I have been told by the Oracle instructor who taught the Advanced PL/SQL class that I attended years ago that part of the problem may have been that I am using Windows XP Home Edition rather than Windows XP Pro. It may also work O.K. with a patch applied. I have heard that it is simple in 10g, but I haven't upgraded to test that yet. Various articles that I have read have indicated that is somehwat of an all or nothing kind of thing. Apparently if you are going to run natively compiled code, you get the best performance by natively compiling all of your code, not just individual pieces. Otherwise, there is so much performance lost in switching back and forth that you may be better off without the native compilation.

Report message to a moderator

Re: PL/SQL To Pro*C Convertor [message #49236 is a reply to message #49234] Sat, 29 January 2005 20:44 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Thanks for the info (you too William). I read about the switch-'problems' too, requiring you to recompile almost your entire db.
I also read in a whitepaper found here that it would lead to about 50% performance gain, but I guess that would involve very intense calculations.
I will discuss it with some of our DBAs (real topnotch in the field of performance) and come back if they have more info.

Report message to a moderator

Previous Topic: find out if CBO or RBO is used
Next Topic: package
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 17 11:10:41 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.