Well just tried my package body, It seems the wrapper does not like the to_lob function. Normal straight code into database the package works, wrap the body and it does not, complains about to_lob. Otherwise will test and let you know. George =20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =20 -----Original Message----- From: Mercadante, Thomas F [mailto:thomas.mercadante@xxxxxxxxxxxxxxxxx]=20 Sent: 12 January 2005 15:27 PM To: Leonard, George; Oracle-L Freelists Subject: RE: Wrapping trigger code George, Can you try it and let us know? Thanks Tom -----Original Message----- From: Leonard, George [mailto:GLeonard@xxxxxxxxxxxxx]=20 Sent: Wednesday, January 12, 2005 8:15 AM To: Oracle-L Freelists Subject: Wrapping trigger code Hi all Can a person use the wrap utility to wrap trigger code as you can with package and procedures? George =3D20________________________________________________ George Leonard Oracle Database Administrator New Dawn Technologies @ Wesbank E-mail:gleonard@xxxxxxxxxxxxx =3D20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =3D20 ________________________________________________________________________ _=3D __________________________ The views expressed in this email are, unless otherwise stated, those of =3D the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o=3D r its management. The information in this e-mail is confidential and is intended solely for=3D =3D20the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut=3D ion or any action taken or=3D20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit=3D y of information and data=3D20 transmitted electronically and to preserve the confidentiality thereof, n=3D o liability or=3D20 responsibility whatsoever is accepted if information or data is, for what=3D ever reason, corrupted=3D20 or does not reach its intended destination. =3D20 ________________________________ -- //www.freelists.org/webpage/oracle-l _________________________________________________________________________= __________________________ The views expressed in this email are, unless otherwise stated, those of = the author and not those of the FirstRand Banking Group an Authorised Financial Service Provider o= r its management. The information in this e-mail is confidential and is intended solely for= =20the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribut= ion or any action taken or=20 omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrit= y of information and data=20 transmitted electronically and to preserve the confidentiality thereof, n= o liability or=20 responsibility whatsoever is accepted if information or data is, for what= ever reason, corrupted=20 or does not reach its intended destination. =20 ________________________________ -- //www.freelists.org/webpage/oracle-l