查看和清除Oracle数据库锁定

create or replace function getDay(parm1 varchar2) return varchar2
is Result varchar2(1000);
begin
Result:='my name is '||parm1;
return(Result);
end getDay;


create or replace function devib2.getMessage(messageId varchar2) return varchar2 is
Result varchar2(1000);
begin
select msg1.message into Result from B00A00DB00001 msg ,B00A00DB00002 msg1
where msg.error_code in(messageId)
and msg.view_message_id = msg1.message_id
and rownum = 1;
return(Result);
end getMessage;


select getMessage('A01EG00002') from dual