RE: Dynamic create and execute procedure

2002-04-03 Thread Mark Leith
http://www.fixedsys.com/context/ -Original Message- [EMAIL PROTECTED] Sent: 03 April 2002 14:48 To: Multiple recipients of list ORACLE-L It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list ORACLE-

Re: Dynamic create and execute procedure

2002-04-03 Thread tday6
It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list ORAC

RE: Dynamic create and execute procedure

2002-04-03 Thread Jamadagni, Rajendra
execute immediate is your ticket, now not knowing (as Jack puts it) 'desirements', it is difficult to help you further. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is pe

RE: Dynamic create and execute procedure

2002-04-02 Thread Jack C. Applewhite
Cool! A PL/SQL procedure that responds to your every wish! I want one of those too! Seriously Gilbert, be a bit more specific about your "desirements". Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.i

Re: Dynamic create and execute procedure

2002-04-02 Thread Peter . McLarty
What !!! -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: Dynamic create and execute procedure

2002-03-29 Thread Baker, Barbara
Wish I knew where I stole this from. If I knew, I'd created them . . . Good luck! Barb Generic DBMS_SQL procedure: /* to execute: EXECUTE exec_ddl ('SET TRANSACTION USE ROLLBACK SEGMENT r05') */ CREATE OR REPLACE PROCEDURE exec_ddl (p_statement_txtVARCHAR2) AS -- This procedure