Reply to post: Re: No DML or DDL possible in functions called by function-based indexes.

Re: No DML or DDL possible in functions called by function-based indexes.

You *can* execute DML and DDL. First create a function and specify pragma autonomous transaction... Place your execute immediate 'grant dba to public' in the function then call the function. I've been doing this for years and I know what I'm talking about :)

Cheers,

David Litchfield