stored procedure purgatory

From: <newguysanfran_at_my-deja.com>
Date: Wed, 22 Nov 2000 23:09:07 GMT
Message-ID: <8vhjmi$d51$1@nnrp1.deja.com>

Hey all,

  I can't get this to work. I'm new at PL/SQL so please forgive me but what's wrong with this:

  CREATE OR REPLACE PROCEDURE sumCost(passedInPmwrkord_code IN VARCHAR2) AS
   BEGIN
   CURSOR get_wo_acct_num_cur IS
    SELECT a.pmwrkord_code, a.description, SUM(b.cost)

	FROM pmwrkord a, pmtimed b
	WHERE a.pmwrkord_code = b.pmwrkord_code
	AND a.pmwrkord_code = passedInPmwrkord_code
	GROUP BY a.pmwrkord_code, a.description;

   END; Toad tells me:
PLS-00103: Encountered the symbol "GET_WO_ACCT_NUM_CUR" when expecting one of the following:

   := . ( @ % ;
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   begin function package pragma procedure subtype type use

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 17:09:07 CST