Hi,

According to the Oracle error message more shared memory is needed than was allocated in shared pool:

The documeted error text states:

If the shared pool is out of memory, either use DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory or increase the amount of shared memory by increasing the value of the initialisation parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
If the large pool is out of memory, increase the initialisation parameter LARGE_POOL_SIZE.

Regards

Moff.