V9 COMPLIE STORED PROCEDURE WITHOUT AN APPLICATION

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>