Re: How to translate PL/SQL to C

2002-05-15 Thread Tim Gorman
main() { EXEC SQL CONNECT scott/tiger@prod; EXEC SQL EXECUTE IMMEDIATE pl-sql-block-text; EXEC SQL COMMIT WORK RELEASE; } Or something like that... What are the reasons for converting PL/SQL to C/C++? There are some things (i.e. operating-system integration, string manipulation,

RE: How to translate PL/SQL to C

2002-05-15 Thread Stephane Faroult
Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...) regards Think that 9i has something of the kind ('native compiler') to boost the performance of stored procedures. However, I don't think that you have access to the C code proper, as you can with Pro*C for instance. My

Re: How to translate PL/SQL to C

2002-05-15 Thread Igor Neyman
On Metalink look at the Note 151224.1 (PL/SQL Native Compilation in Oracle9i). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 9:13 AM Somebody knows how to translate PL/SQL to C or

RE: How to translate PL/SQL to C

2002-05-15 Thread Khedr, Waleed
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=151224.1 -Original Message- Sent: Wednesday, May 15, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...) regards

Re: How to translate PL/SQL to C

2002-05-15 Thread Peter Barnett
This is kind of a Kludge response. Hopefully, someone has a better idea, but try wrapping it in Pro C, run it through the compiler and use the generated C code. --- Bernard, Gilbert [EMAIL PROTECTED] wrote: Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...) regards

RE: How to translate PL/SQL to C

2002-05-15 Thread torben . holm
: Stephane Faroult[EMAIL PROTECTED] Subject: RE: How to translate PL/SQL to C Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...) regards Think that 9i has something of the kind ('native compiler') to boost the performance of stored procedures. However, I don't think that you