The documentation is a little outdated here:
http://docs.openlinksw.com/virtuoso/fn_exec.html
It describes catching exceptions with something like:
if (state <> '00000')
signal (state, msg);
However this will not work and throws various errors. Something like the
below will work:
declare errorCode, errorMessage any;
...
if (errorCode <> 0)
signal (cast(errorCode as VARCHAR), errorMessage);
The state/errorCode variable needs to be an integer for comparison and a
varchar or any in signal().
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
