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, arithmetic, etc) that C/C++ does better than PL/SQL, and some things (i.e. bulk data movement, large-scale data manipulation within the database, etc) that PL/SQL does far better than C/C++. Just curious! It sounds like a bad idea. I just wanted to find out if it is a bad idea based on a misunderstanding of the strong/weak points of each language or whether it was based on some really wild and interesting requirements. And if you decide to go to C/C++ after all, have you given thought as to whether you'll use the Precompilers or OCI/OCCI? ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 7:13 AM > Somebody knows how to translate PL/SQL to C or C++ (ROBOT, Software...) > regards > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bernard, Gilbert > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).