Re: possible to set OMF inside of PL/SQL?

Harald Maier <harald_at_maierh.de> wrote in message news:<m3d68dwycl.fsf_at_ate.maierh>...
> rgaffuri_at_cox.net (Ryan Gaffuri) writes:
>
> > I'm getting errors see below. nothing on metalink. I have a feeling
> > this hasn't been added to the PL/SQL parser yet... Anyone ever get
> > this to work? Its 9.2.0.3.
> > I have the privileges. I'm running it as sysdba.
> >
> > EXECUTE IMMEDIATE 'ALTER SYSTEM SET
> > DB_CREATE_FILE_DEST='||rFilePath.path;
> >
> > Failed To SET DB_CREATE_FILE_DEST ORA-02065: illegal option for ALTER
> > SYSTEM
>
> That is strange, although the Database Reference categorizes
> DB_CREATE_FILE_DEST as follows:
>
> Parameter class Dynamic: ALTER SESSION, ALTER SYSTEM
>
> Either a bug in the documentation or a bug in the implementation. 10g
> reports too this error.
>
> Harald

i can get it to run by using host variables and putting the host variables inside of quotes.

so i use pl/sql with a select into inside my host bind variable.

then in the script(in sqlplus)

do my alter system set ... ':myvariable'; Received on Tue Feb 17 2004 - 14:21:36 CST