creating a stored procedure gets error

From: sunadmn <sunadmn_at_gmail.com>
Date: Thu, 07 Jun 2007 06:11:42 -0700
Message-ID: <1181221902.186965.180630@q75g2000hsh.googlegroups.com>

All I am trying to build a stored procedure inside 10g and I keep getting this error:

SQL> @"C:\Documents and Settings\x591833\Desktop\LastDay.sql"

Warning: Procedure created with compilation errors.

SQL> set arraysize 1
SQL> set maxdata 60000
SQL> show errors procedure LastDay

Errors for PROCEDURE LASTDAY:

LINE/COL ERROR
-------- ----------------------------------------------------

4/3      PL/SQL: SQL Statement ignored
4/7      PL/SQL: ORA-00922: missing or invalid option

This is the query:

CREATE OR REPLACE PROCEDURE LastDay
IS
BEGIN
  set echo off
  set heading off
  COLUMN COUNT FOLD_AFTER 1
  COLUMN GOOD_COUNT FOLD_AFTER 1
  COLUMN FAIR_COUNT FOLD_AFTER 1
  COLUMN PERIOD FOLD_AFTER 1
  select 'COUNT: '||ONLINEFX.EVERYDAY_SUMMARY.COUNT,'GOOD_COUNT: '||

  ONLINEFX.EVERYDAY_SUMMARY.GOOD_COUNT,'FAIR_COUNT: '||
  ONLINEFX.EVERYDAY_SUMMARY.FAIR_COUNT,'UNACCEPTABLE_COUNT: '||
  ONLINEFX.EVERYDAY_SUMMARY.UNACCEPTABLE_COUNT

  from ONLINEFX.EVERYDAY_SUMMARY
  where ONLINEFX.EVERYDAY_SUMMARY.PERIOD = to_char(sysdate-1, 'YYYY-MM- DD');
END; Does anyone have any idea what may be going on here?

Thanks,
-Steve
Received on Thu Jun 07 2007 - 08:11:42 CDT