Re: Can you pass a table name into a stored procedure?

On 15 Dec 2005, deanbrown3d_at_yahoo.com wrote:
> We cannot create views on the fly, from out app. We can create views
> by following the company's application procedures.
>
> And yes, we ca create procedures on the fly, they are used for
> reports.

Why create them? Just run anonymous blocks of PL/SQL?

> And yes, there is a trust issues here, and we like to be trusted and
> continue to do business with them.

I believe the point was that creation of procedures is a more powerful privilege than creation of views. Views are used to read. Procs are used to update.

-- 
Galen Boyer