Re: g

On 13 Feb 2006 22:59:50 -0800, "zafri1936" <zafri1936_at_hotmail.com> wrote:

>Thanks that you are assisting me in this regard.
>Below you find my code, which was written inside the when button press
>trigger. In my application after typing some sql on the screen and
>then press the button, the application generate the execution plan for
>that SQL. That's why my scripts accessing 10G Sqlplus via forms 6i.
>Should I also put all these work in forms ddl instead of this?
>The users system is login successfully on forms 6i but later when the
>sql scripts try to connect to databases after pressing the button, the
>error comes.
>
>Thanks
>
>Zafri

Could you *PLEASE* stop posting this UTTER CRAP and follow up my advice?
You are
a) re-inventing the wheel, as this script already exists in $ORAC LE_HOME/rdbms/admin
b) you should run the create table statement (NOT the script), as a string using forms_ddl or dbms_sql
c) As this is an installation like type task, it shouldn't be available when hitting a button.

If you expect anyone in this group to do your work for you, you can safely forget about that.
If the advice above is too difficult for you, I suggest you hire a consultant to write the application for you.

--
Sybrand Bakker, Senior Oracle DBA