Re: Using Alter session enable parallel dml within a stored procedure

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 22 Jul 2003 22:30:48 +0100
Message-ID: <17brhvg4f75skp4gjgvhq3p999nhb1pipr@4ax.com>

On 22 Jul 2003 08:52:17 -0700, elanghi_at_yahoo.com (Erica) wrote:

>I am building a stored procedure in which I want to use a parallel
>query.
>
>Usually in a sql script I use the command "alter session enable
>parallel dml".
>Is this allowed in pl/sql as well?
>Browsing the documentation I found a reference to the DBMS_SESSION
>package, provided by Oracle in order to access some of the
>functionalities of the ALTER SESSION command, within a stored
>procedure.
>Unfortunately I haven't found a function which provides the "enable
>parallel dml" behaviour.
>
>Is there any alternative?

Look up EXECUTE IMMEDIATE.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Received on Tue Jul 22 2003 - 16:30:48 CDT