OWA_COOKIE.GET and error message ORA-01403
MtranApr 20 2011 — edited Apr 20 2011Hello Everyone,
I have a process Get Username Cookie as below:
declare
v varchar2(255) := null;
c owa_cookie.cookie;
begin
c := owa_cookie.get('LOGIN_USERNAME_COOKIE');
:P101_USERNAME := c.vals(1);
exception when others then null;
end;
When the process run, it raises an error message,
"Invalid PL/SQL expression condition: ORA-01403: no data found Invalid PL/SQL expression condition: ORA-01403: no data found"
How do I not show this error on the screen but something more meaningful?
Thanks so much in advance.
MT