Thanks Dhevendra for the response .

One more doubt the stored procedure internal executing some DDL activity , if the base use don't have DDL privilege after upgrade and the same  stored procedure  is calling from application then below exception is showing in log .

SPPR_DEFRAGMENT_TABLE procedure: calling from application, which is performing some DDL’s is throwing error in application logs. Input to this procedure is table_name and schema_name. Not sure what are all the inputs the application is passing. Throwing below error..

Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

ORA-06512: at "GIN.SPPR_DEFRAGMENT_TABLE", line 57

ORA-06512: at line 1

PLSQL code related to this is as follows

CREATE OR REPLACE procedure GIN.sppr_defragment_table

( p_table_name IN VARCHAR2,

  p_schema_name IN VARCHAR2

) authid current_user

AS

l_temp_tablename varchar2(64) ;

l_actual_tablename varchar2(64) := p_schema_name || '.' || p_table_name;

BEGIN

if length(l_actual_tablename) <=25 then

      l_temp_tablename := l_actual_tablename || '_temp';

else

      l_temp_tablename := substr(l_actual_tablename, 1, 25) || '_temp';

end if;    

  BEGIN

     EXECUTE IMMEDIATE 'DROP TABLE '|| l_temp_tablename || ' PURGE';

  EXCEPTION

     WHEN OTHERS THEN

        IF SQLCODE != -942 THEN

           RAISE;

        END IF;

  END;

EXECUTE IMMEDIATE 'CREATE TABLE ' || l_temp_tablename || ' AS SELECT * FROM ' || l_actual_tablename;

EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_actual_tablename;

EXECUTE IMMEDIATE 'INSERT INTO ' || l_actual_tablename || '  SELECT * FROM ' || l_temp_tablename;

EXECUTE IMMEDIATE 'DROP TABLE '|| l_temp_tablename || ' PURGE';

EXCEPTION

 WHEN OTHERS THEN RAISE;

END;

/