Hi all, Im getting a
"Conversion between byte data and types is illegal" error, and I have no idea why.
Using simple code I create two tables which are identicle but with different names and try put the same information into each, it works on the first one but I get the above error message for the second table.
Any ideas guys? Would really appreciate help on this, its doing my head in. Below is the code
Just out of interest sake I had triggers on them but have dropped then since (1st 3 lines) and not put them back on again, and still getting the error.
"DROP TRIGGER KYC_TEST.RET_H_RSK_UPT_TRIG;
DROP TRIGGER KYC_TEST.RET_M_RSK_UPT_TRIG;
DROP TRIGGER KYC_TEST.RET_L_RSK_UPT_TRIG;
DROP TABLE KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP ;
DROP TABLE KYC_TEST.RETRO_MEDIUM_RISK_REVIEW_POP;
DROP TABLE KYC_TEST.RETRO_LOW_RISK_REVIEW_POP;