Re: variable binding in DDL statements problem

To solve you problem you could rewite the view to use the sys_context function to provide session specific parameters. To set the context to be used in the view you would either need to have a database event logon trigger or execute a procedure to set the context variable values prior to making the call.

But why not just directly query the table using bind variables either in your application or in a stored procedure passing back a reference cursor?

Knowing what your front-end application is and what version of Oracle you are working would be useful information for providing a solution that would work for you.

HTH -- Mark D Powell -- Received on Wed Feb 16 2005 - 15:31:34 CST