Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: stored procedure purgatory
variables declaration should be before BEGIN
-- Rastko Potocnik rastko.potocnik_at_rtvslo.si newguysanfran_at_my-deja.com wrote in message <8vhjmi$d51$1_at_nnrp1.deja.com>...Received on Thu Nov 23 2000 - 01:40:19 CST
>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.
![]() |
![]() |