Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: replace text in a file, with PL/SQL
First, thanks to both of you for your answers!
Then, to Daniel:
I have a (big!) sql script, with a &&var, and I would like to automate its
execution in a stored procedure,
without having to give the value (in sql*plus, for example); so, I have to
replace the &&var string in the script
by a value given by the procedure. Finally, I launch the script from the
procedure (I don't know yet how to do this!!).
To Rauf:
Unfortunately, the script is bigger than 32000!
Thanks again!
Celine.
"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> a écrit dans le message
news: af6p5j$7u$1_at_wanadoo.fr...
> Hello,
>
> I've an opened file in a PL/SQL procedure (with UTL_FILE), and I would
like
> to know if it's possible
> to replace a string in this file by another string, in my procedure?
>
> Thanks!
>
> Céline.
>
>
Received on Tue Jun 25 2002 - 02:10:13 CDT