Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00103: Encountered !!!!!!!!!!
PLS-00103: Encountered !!!!!!!!!! [message #18476] Fri, 01 February 2002 02:26 Go to next message
Rm69
Messages: 39
Registered: January 2002
Member
Error:
PLS-00103: Encountered the symbol "I_BRANCH" when expecting one of the following:

; is with authid deterministic parallel_enable as

when l compile this procedure.

l want to declare branch,brokercd,sbrokercd so l can select them into the fields specified in my insert statement. THese fields are coming from the same table that l'm selecting received.....etc

CREATE OR REPLACE Procedure Mis_WorkFlowCapitalOriginal
(v_start_date date,v_end_date date)

i_branch in varchar(10);
i_sbrokercd in varchar (10);
i_brokercd in varchar2(10);

AS

BEGIN

Insert into mis_wrkflow_cap (sbrockercd,received,prequota,batched,capture_date,change_date)

Select sbrokercd,received.capital,prequota.capital,batched.capital,sysdate,v_start_date

from (SELECT sum(CAPITAL) capital,brokercd
from ZW30800P
where branch=i_branch
where SCDATE between v_start_date
and v_end_date)
received,

(SELECT sum(CAPITAL) capital
from ZW30800P
where STATUS = 'PRE'
and PQDATE between v_start_date
and v_end_date)
prequota,

(SELECT sum(CAPITAL) capital
from ZW30800P
where STATUS = 'BAT'
and BADATE between v_start_date
and v_end_date)
batched,

end;
Re: PLS-00103: Encountered !!!!!!!!!! [message #18478 is a reply to message #18476] Fri, 01 February 2002 03:52 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
Put "IS" before i_branch. Drop the "AS".

I've seen zw30800p a lot on this forum. You seem to have a lot of questions...maybe you need to take a class.
Previous Topic: SQL%NOTFOUND
Next Topic: Summary Scenario
Goto Forum:
  


Current Time: Thu Mar 28 17:06:23 CDT 2024