i want convert DBMS_OUTPUT.PUT_LINE(sqlcode||SQLERRM); in mysql. i replaced with PUT_LINE(concat(infull(sqlcode,''),infull(SQLERRM, ''))); but showing errors- unexpected identifier. please help me
create procedure Purge_Data is begin declare exit handler for sqlexception begin PUT_LINE(concat(infull(sqlcode,''),infull(SQLERRM, ''))); delete from IP21_TAGDATA where TIMESTAMP <= (trunc(sysdate) - 2); delete from IP21_TAGDATA1 where TIMESTAMP <= (trunc(sysdate) - 2); end;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)