Re: g

[Quoted] On 11 Feb 2006 06:21:55 -0800, "zafri1936" <zafri1936_at_hotmail.com> wrote:

>I am using Text_IO in my form's when button press trigger , inorder to
>create the
>text file, then in the same when button press triger
>I am calling RMAN via host command in order to run the script which was
>created by text_IO.
>
>Below you find some of the code. I will appreciate if you solve the
>problem.

I'm not sure why you are using this code when you can use the dbms_sql package to create a table, without any need to call any host command to create a table.
Please look up dbms_sql in the PL/SQL supplied packages manual on http://tahiti.oracle.com and throw this horrible code away as soon as possible.
As Oracle comes with a script to create the plan table, I'm also not sure why you are trying to reinvent the wheel, so I'm not sure why you can't make use of provided facilities.

--
Sybrand Bakker, Senior Oracle DBA