Re: Error using dynamic sql.

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Fri, 15 Jan 1999 12:27:16 +0100
Message-ID: <369F2614.422E8D99@Privat.Post.DE>

Nicodemus Chan schrieb:
>
> Actually, the problem is solved, it was merely a permission problem.
> The real error message I got was the one below.
>
> SQLWKS> execute generate.post_proc(335)
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "CLASSADS.GENERATE", line 349
> ORA-06512: at line 2

Be aware that roles are turned off when processing procedures. So if you want to access other schemas in the SP the necessary rights have to be granted directly to you. Same with the right to create a table.

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Fri Jan 15 1999 - 05:27:16 CST