<html>
<body>
Hello all,<br>
(and sorry if this has been aswered before)<br><br>
Take this piece of code for example:<br>
.....................<br>
<font face="Courier, Courier">begin<br>
_res.code:=1;<br>
select id into iid from log where id=_id;<br>
if not found then begin<br>
_res.msg:=''insert'';<br>
<b>insert into log (log, data)
values (_log, _data);<br>
if not found</b> then
begin<br>
_res.msg:=_res.msg || '' error'';<br>
_res.code:=-1;<br>
end;<br>
end if;<br>
end;<br>
else begin<br>
</font>.....................<br>
The thing is if _data (parameter) is null and table has a (data <>
null) check, the insert would fail and abort the function before my
"if not found" test.<br><br>
I'm porting a java app. from mssql to postgresql, and the java code
relies on the stored procedure to always return it's status (in _res.code
in this case).<br><br>
Is there anything I can do to make sure the function always returns _res
?<br>
Something along the lines of Oracle's exception handling, or the @@error
trick in mssql ?<br><br>
<br>
<x-sigsep><p></x-sigsep>
Regards,<br>
--<br>
Radu-Adrian Popescu<br>
CSA, DBA, Developer<br>
Aldratech Ltd.</body>
</html>