tag:blogger.com,1999:blog-1561253375800464394.post1441545309499822694..comments2024-03-28T10:48:36.635+01:00Comments on Denes Kubicek ApEx BLOG: APEX 5.0 - PL/SQL Function Returning Error Text - Bug 20971572Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1561253375800464394.post-86060668619342776452016-08-29T08:08:02.217+02:002016-08-29T08:08:02.217+02:00I would say you should use a name instad of "...I would say you should use a name instad of "Anonymous" :) and I would also say "think twice before posting something". ;)<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-55959643083178274672016-08-28T12:40:36.415+02:002016-08-28T12:40:36.415+02:00I would say you should't use variable for erro...I would say you should't use variable for error text:<br /><br />BEGIN<br /> IF :job='CLERK' and :sal > 3000<br /> THEN<br /> RETURN 'Salary may not exceed 3000 for the job CLERK.';<br /> END IF<br />END;<br /><br />but if you want to use variable then you should check it is it empty or null before return:<br /><br /> IF LENGTH(v_error)>0 <br /> THEN <br /> RETURN v_error;<br /> END IF;<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-26892403220177649942015-06-17T11:01:46.642+02:002015-06-17T11:01:46.642+02:00Yes , in apex 4.2.4 Error message was allowed to b...Yes , in apex 4.2.4 Error message was allowed to be emptyAnonymoushttps://www.blogger.com/profile/06752801877767082594noreply@blogger.com