Thread: java.sql.SQLException: ORA-28115: policy with check option violation
View Single Post
  #8 (permalink)  
Old October 4th, 2007, 12:23
cunninghamg cunninghamg is offline
Member
  
Join Date: Mar 2007
Location: Bedfordshire England
Posts: 58
Thanks: 3
Thanked 10 Times in 9 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
cunninghamg is on a distinguished road
Send a message via AIM to cunninghamg Send a message via MSN to cunninghamg Send a message via Skype™ to cunninghamg
Re: java.sql.SQLException: ORA-28115: policy with check option violation
in your insert statement - you do not reference the domain_name field.
Therefore OTM thinks you're trying to write to PUBLIC - and you're not allowed to write to public unless you're logged in as DBA.ADMIN

Hope this helps
Gary
Reply With Quote
The Following 2 Users Say Thank You to cunninghamg For This Useful Post:
bmj_23 (October 4th, 2007), svenhaul (July 31st, 2008)