Re: [sqr-users] why isn't this working? phase ][

["the dragon" <ceprn@hotmail.com>]

All,

I slapped the select into an array, and I am processing the array.  It isn't 
as elegant as I wanted, but as long as it works.  Thank you for your help.

PS I had to disable the on-error functionality for 'inoperative' objects.

clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)



----Original Message Follows----

Oracle does in fact commit when you execute DDL, but that closes only
FOR UPDATE cursors; within PL/SQL loops I do stuff like this all the
time. In any case, I'd find it hard to blame Larry Ellison, tempting
though it be, for problems with 'db2 udb v7.2'

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users