Re: stored procedure purgatory

<newguysanfran_at_my-deja.com> wrote in message news:8vhjn9$d58$1_at_nnrp1.deja.com...
> 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

Declare your cursor before the BEGIN. After the BEGIN utlize (open, fetch, etc.) it.

--
Michael O'Neill
mjoneill_at_email.com