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

Thread: Trigger

  1. 05-06-2003, 06:31 AM #1
    akhil
    akhil is offline Member
    Join Date
    Feb 2001
    Posts
    103

    Trigger

    Hi,

    I am having a error in my database trigger. When i do show error i am unable to see the compilation errors. I have query user_errors to check the compilation. Is there any setting required at sqlplus level to see the error.

    Thanks in anticipation.
    When the going gets tough, the tough gets going
    Reply With Quote Reply With Quote
  2. 05-06-2003, 07:51 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Try using full SHOW ERROR sintax:
    Code:
    SHOW ERROR TRIGGER trigger_name
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width