Darsh12345 Ответов: 0

Как написать DBMS_OUTPUT.PUT_LINE(sqlcode||SQLERRM); в mysql?


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;

0 Ответов