stored procedure purgatory

From: <newguysanfran_at_my-deja.com>
Date: Wed, 22 Nov 2000 23:09:54 GMT
Message-ID: <8vhjo1$d5b$1_at_nnrp1.deja.com>

[Quoted] Hey all,

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

[Quoted]   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:

   := . ( _at_ % ;
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 Thu Nov 23 2000 - 00:09:54 CET