Title: RE: Converting Longs
Jay,
Well since he says Oracle recommends not using Longs but Oracle itself uses Longs, have the luser submit a TAR or give him Uncle Larry's email address. Should be good for a laugh or two.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL
Depending on whether you wish to humiliate and demoralize
the duhveloper, or you think there may be hope and you wish
to educate him, one of the following may work.
1. Show him the the sys.trigger$ table and point him at documentation
that will help him convert the WHENCLAUSE column to a CLOB