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

On 18 Dec 2005 08:25:01 -0600, Galen Boyer <galen_boyer_at_yahoo.com> wrote:

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

The latter statement is probably not readily true in a reporting environment, where procedures return REF CURSORs. Remember also sql server aficionados never run direct sql, but always use stored procedures returning REF CURSORs.

--
Sybrand Bakker, Senior Oracle DBA