Re: stored procedure purgatory

Write BEGIN after cursor declaration.

<newguysanfran_at_my-deja.com> wrote in message news:8vhjo1$d5b$1_at_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:
>
> := . ( _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 Wed Nov 22 2000 - 20:17:35 CET