Re: package invocation CALL vs EXEC

From: Mohamed Houri <>
Date: Sun, 1 Feb 2015 20:09:52 +0100
Message-ID: <>

I know one difference in calling a package using

*call package.procedure()*


*  package.procedure()*

In case you use the cursor sharing FORCE, bind variable substitution will occur in the first manner of calling the package while it will not occur in the pl/sql begin end call

As a call represents a SQL function, exception like no_data_found and when to many rows will not be reported as error while in th begin end call those two errors will be reported

I didn't tested the comparison between call and exec.

Best regards
Mohamed Houri

2015-02-01 19:17 GMT+01:00 Ls Cheng <>:

> Hi all
> Does anyone know the difference between invoking a package using CALL or
> I hit a bug recently, 15882436, and wondering if anyone know the
> difference between using call and exec.
> Even the bug is for Exadata I have been bitten in both Exadata
> and AIX environments
> Thanks


Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Member of Oraworld-team <>

Visit My         - Blog <>

Let's Connect -
Profile <>*

My Twitter <>      - MohamedHouri

Received on Sun Feb 01 2015 - 20:09:52 CET

Original text of this message