Hi, I am trying to catch exception through below handler. declare continue handler SQLEXCEPTION begin .... end; My assumption is that the below statement should call the hadler and the exception should be handled. update table set col = external_udf(); --This udf returns some error messagr and I want to continue my execution and dont want the execution to be stopped. But through the continue handler I am unable to achieve this as it is not catching the error thrown by the external udf Is there any other way to handle the exceptions thrown by external udf??
Nice explanation. Just a request can please make another video with a bit more complex requirement like including more than 1 loop and use of case and join operations. I am a beginner on this one and trying to learn more about it. Anyway, this video is really nice and crisp. Thanks !
Hi,
I am trying to catch exception through below handler.
declare continue handler SQLEXCEPTION
begin
....
end;
My assumption is that the below statement
should call the hadler and the exception should be handled.
update table set col = external_udf();
--This udf returns some error messagr and I want to continue my execution and dont want the execution to be stopped.
But through the continue handler I am unable to achieve this as it is not catching the error thrown by the external udf
Is there any other way to handle the exceptions thrown by external udf??
Nice explanation. Just a request can please make another video with a bit more complex requirement like including more than 1 loop and use of case and join operations. I am a beginner on this one and trying to learn more about it. Anyway, this video is really nice and crisp. Thanks !
I will try my best