Code:
IF length(COUNTRY_ORIGIN)= 2 then
COUNTRY_ORIGIN := :new.COUNTRY_ORIGIN;
ELSE
akeem
Last Activity: Aug 30 '18, 03:30 PM
Joined: Aug 23 '18
Location:
-
akeem started a topic I am getting Bad bind variable error when i try to create a trigger before insert, upin OracleI am getting Bad bind variable error when i try to create a trigger before insert, up
I need help on this. I want to create a trigger that should fire before update(back end) when an insert occurs on a table(front end)but the back end table has one of it column datatype(NVARCH AR2(2) different from the front end datatype(VARCHA R2(35)table and as such the trigger is not working. So i introduced a case function
...Last edited by zmbd; Aug 26 '18, 10:16 PM. Reason: [z{please format your Script/Code using the [CODE/] format tool}]
No activity results to display