Re: g

[Quoted] Should we also run the sql script via forms' dbms_sql and perform O/S task?
I will appreciated if you make some code regarding dbms_sql using my code.
I know people in this forum are busy but I will appreciated if someone can do it

Zafri

Sybrand Bakker wrote:
> 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
Received on Sun Feb 12 2006 - 17:28:38 CET