| PLS-00103: Encountered !!!!!!!!!! [message #18476] |
Fri, 01 February 2002 02:26  |
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
