When you are using PITSS.CON Source Control, you have the option of checking in or checking out files to/from either the application server or the client machine. There is a known issue where you may run into errors when trying to check in or out files to/from the client. Examples are shown below:
Check Out Files to Client:
run_task.check_out_file error (1): ORA-06544: PL/SQL: internal error, arguments: [77604], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [77604]
Check In Files to Client (New Files):
run_task.add_file error (2): file cannot be loaded ORA-06544: PL/SQL: internal error, arguments: [77604], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [77604]
Solution
PITSS.CON relies heavily on the WebUtil library to allow the client to interact with the server. Depending on how the public synonym for the WebUtil DB package “webutil_db” was created, it needs to be created within the WebUtil schema itself. To solve this problem, you will need to perform the following steps in the database where the WebUtil schema is located (NOTE: DBA access is required):
Conditional steps:
- If a public synonym webutil_db is created, run the following as the DBA user: drop public synonym webutil_db;
- Make sure everybody is out of PITSS.CON and any forms application which uses WebUtil
Steps:
- Run the following SQL statement: grant public synonym to webutil; (NOTE: If another user has the WebUtil package, grant public synonym to that user instead)
- Log into the database (i.e. sqlplus) as the webutil user (or the user who has the webutil_db package)
- Run the following SQL statement: create public synonym webutil_db for webutil_db;
- Log out of the user and log in as a DBA user
- Run the following SQL statement: grant execute on webutil_db to public;
- Compile the webutil.pll library using the webutil user
After applying the steps above, you should be able to check in and check out files to/from the client.
