Re: call my_proc(); or begin my_proc(); end;
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Mon, 7 Apr 2014 11:13:57 +0100
Message-ID: <DUB406-EAS318089D793418B71388975AA1680_at_phx.gbl>
> What do you think?
>Do you see any issues with using a call my_proc();
>instead of begin my_proc(); end;
Date: Mon, 7 Apr 2014 11:13:57 +0100
Message-ID: <DUB406-EAS318089D793418B71388975AA1680_at_phx.gbl>
> What do you think?
>Do you see any issues with using a call my_proc();
>instead of begin my_proc(); end;
For scheduled jobs, I don't see an issue.
But I have seen an issue in JDBC once where the call to a stored proc
was missing a wrapping set of {}
This meant that the call to sp was translated to CALL rather than being wrapped with BEGIN ... END;
As a result, a no_data_found exception was swallowed.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 07 2014 - 12:13:57 CEST