Re: PLSQL and Form 4.5

>In article <3368BA98.41C6_at_prpi.com>,
>Can I create a form and at run time give the user the ability to write
>PLSQL code in a box, and then be able to compile and execute the code.
>Is this possible? Any help would be greatly appreciated.

If you are giving a user that capability, why not give them access to SQL Plus?

You probably can do it in a form... But how would you pass back error messages? I would try to use Thomas Kyte's Execute_Immediate procedure. To find it, go to Deja News: http://www.dejanews.com/ and use a Power Search "create query filter" to search:   Newsgroups: comp.databases.oracle.*
  Author: tkyte_at_us.oracle.com
On the retrieved documents, search for: execute_immediate

If you can't find a few of his articles, I can pass along a copy.

Steve Cosner

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet