Finding Package running behind a concurrent request
Finding Package running behind a concurrent request
SystemAdministrator>concurrent>Program>define>Search
Search for the concurrent request
Ok
Copy Executable name
Systemadministrator>concurrnet>Program>Executable
Enter <F11>
Paste in executable field
Enter <Ctrl+F11>
Executable File Name is the name of Package
Regards
Soban Ali
Hello Ali,
ReplyDeleteAt this step you can run the following SQL script to trap the full package source :
SQL> conn apps/***
SQL> set lines 1000 pages 0 trimspool on
SQL> select text from dba_source where name='' and type='PACKAGE BODY' order by line
SQL>.
SQL> spool MYPACKsource.txt
SQL>/
SQL> spool off
regards
Lotfi C.