Xref: alice comp.databases.oracle:73121 Path: alice!news-feed.fnsi.net!dca1-hub1.news.digex.net!digex!newsfeed1.swip.net!masternews.telia.net!News.Amsterdam.UnisourceCS!news.wxs.nl!user From: _ronr_@_wxs.nl_ (Ronald) Newsgroups: comp.databases.oracle Subject: Re: what's wrong with this DYNAMIC SQL ??? Date: Tue, 05 May 1998 18:46:04 +0200 Organization: No organization at all Lines: 22 Message-ID: References: <3550f5ef.5968542@192.86.155.100> In article <3550f5ef.5968542@192.86.155.100>, tkyte@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@wxs.nl http://home.wxs.nl/~ronr/RonR.html (last update: dec 31, 1997)