Login to sqlplus as the user who owns the package/package body.
SQL>spool package_name.bkp
SQL>select text from user_source where name='&PACKAGE NAME' and type='PACKAGE';
SQL>select text from user_source where name='&PACKAGE NAME' and type='PACKAGE BODY';
SQL>Spool off;
SQL>spool package_name.bkp
SQL>select text from user_source where name='&PACKAGE NAME' and type='PACKAGE';
SQL>select text from user_source where name='&PACKAGE NAME' and type='PACKAGE BODY';
SQL>Spool off;
Regards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.