Click here to Skip to main content
15,891,907 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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


What I have tried:

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;
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900