Re: what's wrong with this DYNAMIC SQL ???
From: Ronald <_ronr__at__wxs.nl_>
Date: Tue, 05 May 1998 18:46:04 +0200
Message-ID: <B1750EEC966829B9A_at_ut0259.wxs.nl>
mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: dec 31, 1997) Received on Tue May 05 1998 - 18:46:04 CEST
Date: Tue, 05 May 1998 18:46:04 +0200
Message-ID: <B1750EEC966829B9A_at_ut0259.wxs.nl>
In article <3550f5ef.5968542_at_192.86.155.100>, tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>There are a couple of things wrong with your routine
>
>- vyl_id -- undefined variable?
>- you parse the CURSOR_COALESCE with a value contained in "FID". FID is not
>initialized to anything and you can't use a bind variable there.
>
>If you have a version of the database less then 7.3, you can use the following
>procedure (which should be owned by SYS and execute granted to whomever should
>have execute) to coalesce contigous free extents. In 7.3, you can just use the
>coalesce option of the alter tablespace command directly.
Thanks, I have something usefull to study on !
Ronald
mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: dec 31, 1997) Received on Tue May 05 1998 - 18:46:04 CEST