Steps:
1. command prompt
2. launch sqlplus
3. signing to SQL Plus with report user (user: reportuser@rproods password:report)
4 complie the proceudre: @C:filename.pck; (“@” Path Filename)
Example:
Jeff C:Documents and SettingsJeff.BIGHAIRYDOG.000>sqlplus
SQL*Plus: Release 11.1.0.7.0 – Production on Mon Jul 11 10:01:29 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: reportuser@rproods
Enter password:
Connected to:
Oracle Database 11g Release 11.1.0.7.0 – Production
SQL> @D:Retailpro9ReportsREPORT_JOURNALS_CUSTOM.pck;
Package created.
Package body created.
SQL>