Stored Procedures

From: <jscichocki_at_my-deja.com>
Date: Tue, 02 Jan 2001 19:44:18 GMT
Message-ID: <92tb2g$dt3$1@nnrp1.deja.com>

Trying to create the following stored procedure. Everytime I try to create it, it compiles with errors. I have validated the query. It functions perfect. I have two other procedure that are giving me the same grief (also select oriented as opposed to updates or deletes).

CREATE OR REPLACE PROCEDURE CUSTOM.MY_UPS_GREETED   (HOME_STORE IN VARCHAR2, TODAY IN VARCHAR2) AS     BEGIN

        SELECT COUNT(EMP_CD) GREETED
        FROM   CUSTOM.UPS_OPPORTUNITY
        WHERE  HOME_STORE_CD = HOME_STORE
          AND  UP_DATE = TODAY
          AND  EMP_CD <> 'ZZZ';

    END; Thanks for your help.

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 13:44:18 CST