Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how can display massage in plsql in apex

i use this pl/sql in dynamic action to date field when enter date it check period if it lock display message and if not lock insert date into table it's ok display message but the display like this

mes.pngthis is code '''' could you please anyone tell my why display look like that "
or is there anyway to display only the message
DECLARE
lck number;
BEGIN
select nvl(count(*),0) into lck from LOCKOPER where STAT=1 and :p78_DATE_BILL between FRM_DATE and TO_DATE;
if lck=0 then
INSERT INTO BILL_RECIV(no_brch,NO_GROP,NO_MEBER,TYP_BILL,NO_FUND,DATE_BILL,NO_BILL,STATUS_DOC,cur,eqv,DATE_OPR,DETAIL)
VALUES(br,:p78_NO_GROP,NO_MEm,:p78_TYPBILL,:p78_NO_FUND,:P78_DATE_BILL,Nobill,0,cur,1,:p78_OPR,' saving month '||:P78_D);
elsif lck=1 then
apex_util.set_session_state('this month is locked from manager');
end if;
END;
image.png

Comments
Post Details
Added on Sep 5 2022
5 comments
5,179 views