Hi All,
in Packaged Procedure, we are using the below line,
EXECUTE IMMEDIATE 'ALTER SESSION SET CURSOR_SHARING=FORCE';
The procedure is marked, pragma autonomous_transaction.
While try to execute the procedure, it not executing.
If I commended out the line "EXECUTE IMMEDIATE 'ALTER SESSION SET CURSOR_SHARING=FORCE';", it got executed successfully.
I want understand what is happening while calling Alter session inside the autonomus transaction, please explain...