DBMS_SQL and DBMS_OUTPUT package

Hi,
I have two questions that I hope someone can answer:

I am trying to create a table using a PL/SQL procedure who's input parameter is the table name. I use the DBMS_SQL.PARSE procedure to do this. I can create the procedure sucessfully however when I try an execute it I get the following message:

ORA-01031: insufficient privileges

This message comes from my procedure where I trap all exceptions and print out the error message. I can create a table without this PL/SQL procedure in SQL so the user I am logining as has sufficient privileges and owns the procedure too. I am running the procedure from SQL. What's wrong?

My next question is regarding the DBMS_OUTPUT.PUT_LINE procedure. It does not work, i.e. does not print out anything, when the procedure is executed from SQL. I tried DBMS_OUTPUT.ENABLE before DBMS_OUTPUT.PUT_LINE and it still does not work. It only works when I do the following in SQL:

set serveroutput on;

Isn't DBMS_OUTPUT.ENABLE equivalent to running a 'SET SERVEROUPUT ON' ?

Thanks,
Haresh Received on Wed Oct 29 1997 - 00:00:00 CST