Re: dynamic pl/sql

From: Hakan Eren <nvcinc_at_ibm.net>
Date: Sun, 26 Jul 1998 16:59:25 -0400
Message-ID: <35BB98AD.E5FF0610@ibm.net>

Hi,

One small thing to remember: roles are never enabled during dynamic sql execution. You should grant rights explicitly to the users who will run procedures/functions/packages.

Also it is not dynamic pl/sql only SQL.

Regards

Hakan

shailesh wrote:

> hi,
> It's urgent !!!
> can anybody tell me which oracle utility is used for writing DYNAMIC PL/SQL.
> Is it DBMS_SQL.
> thanks in advance.
> shailesh
Received on Sun Jul 26 1998 - 15:59:25 CDT