Re: call my_proc(); or begin my_proc(); end;

From: Dominic Brooks <>
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.

Received on Mon Apr 07 2014 - 12:13:57 CEST

Original text of this message