Re: call my_proc(); or begin my_proc(); end;
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "mohamed.houri@xxxxxxxxx" <mohamed.houri@xxxxxxxxx>
- Date: Mon, 7 Apr 2014 11:13:57 +0100
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
