Re: Error while executing DBMS_SQL

Hi Vishis.
You do not write what you mean <some sql statement>. BUT if you try to do some DDL or some DML ops you MUST grant this privilege directly to user doing this.
Example: GRANT CREATE ANY TABLE TO bors; When bors trying to use DBMS_SQL to execute some CREATE statement his will work.

Thuink this helps. Bors/

>Hi everbody
>I get the following error while executing a dynamic SQL statement using
>DBMS_SQL
>
>ERROR at line 1:
>ORA-01031: insufficient privileges
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
>ORA-06512: at "SYS.DBMS_SQL", line 25
>ORA-06512: at "SMSARE.CR_TAB", line 27
>ORA-06512: at line 1
>
>My code is as follows
>....
>sqlstmt := <some sql statement>;
>sys.dbms_sql.parse(source_cursor, sqlstmt , dbms_sql.native);
>.....
>I have connected as SYS and this works correctly. Howver , this does not
>work if I connect as some other user(myuser) . Looking at the error , I
>have also created synonyms for DBMS_SQL and granted permissions to DBMS_SQL
>AND DBMS_SYS_SQL to myuser. However, this still gives the same error
>message
>Any pointers will be of great help.
>TIA
>
>Regards
>Vishis
>
Received on Mon Jan 05 1998 - 00:00:00 CST