Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to call oracle triigers in vb

Hi,
I would like to know the syntax of callling an oracle trigger through visual basic 6.0.


Eg:Suppose there is a table named emp in oracle.....having all the employee details..At the time of inserting records into the table if the experience of the employee is less than 2yrs then a trigger should be fired that will automatically insert 2 instead of the text typed in the experience textbox in visual basic.



Can anybody help!!!!!!!!!!!!!!!!!!

Comments

  • BitByBit_ThorBitByBit_Thor Member Posts: 2,444
    : Hi,
    : I would like to know the syntax of callling an oracle trigger
    : through visual basic 6.0.
    :
    :
    : Eg:Suppose there is a table named emp in oracle.....having all the
    : employee details..At the time of inserting records into the table if
    : the experience of the employee is less than 2yrs then a trigger
    : should be fired that will automatically insert 2 instead of the text
    : typed in the experience textbox in visual basic.
    :
    :
    :
    : Can anybody help!!!!!!!!!!!!!!!!!!

    Couldn't you check the input from the user in your VB program and do the modification yourself? Or perhaps run a script in the Oracle database that looks for employees with less than 2 years experience and sets the correct column-value.

    Best Regards,
    Richard

    The way I see it... Well, it's all pretty blurry
Sign In or Register to comment.