DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Issue with BEFORE INSERT trigger

Threaded View

  1. #1
    Join Date
    Oct 2006
    Posts
    175

    Issue with BEFORE INSERT trigger

    Hi all
    I've caught into strange situation here. Attached query works just fine in our Dev RAC, but just won't in our Prod RAC. We have a BEFORE INSERT trigger that takes nextval from a sequence. I've attached the query, trigger, sequence and table DDL. When I run the query it gives me
    'ORA-01400: cannot insert NULL into ("USER_T"."USR_LLG_DETAIL"."LETTERID")'.

    Any hints, suggestions are appreciated.

    Thanks
    gtcol
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width