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

rgaffuri_at_cox.net (Ryan Gaffuri) writes:

> 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.
>>

> 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';

Uups. You are right.

  SQL> alter system set db_create_file_dest = '/tmp';

  System altered.

Harald Received on Wed Feb 18 2004 - 00:15:52 CST