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>

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s almost 30 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s 25 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!