Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00103: Encountered
PLS-00103: Encountered [message #18382] Wed, 30 January 2002 01:01 Go to next message
Rm69
Messages: 39
Registered: January 2002
Member
I GET THE FOLLOWING ERROR !!!!

PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:

:= . ( % ;
The symbol ";" was substituted for "SELECT" to continue.

CREATE OR REPLACE Procedure Mis_Persal_insertProcTest
(v_start_date date,v_end_date date)
As
Begin

mis_Persal_t(brokercd,type,loan_count,summary_date)

select bro386,sum(da1386),count(da1386),sysdate from
pw38600p
where ah1386 not like'%african bank%'
and did386 between v_start_date and v_end_date)
;

select bro386,sum(da1386),count(da1386),sysdate from pw38600p
where bro386 ='hmc' and ah1386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da2386),count(da2386),sysdate from pw38600p
where bro386 ='hmc' and ah2386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da3386),count(da3386),sysdate from pw38600p
where bro386 ='hmc' and ah3386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da4386),count(da4386),sysdate from pw38600p
where bro386 ='hmc' and ah4386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da5386),count(da5386),sysdate from pw38600p
where bro386 ='hmc' and ah5386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da6386),count(da6386),sysdate from pw38600p
where bro386 ='hmc' and ah6386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da7386),count(da7386),sysdate from pw38600p
where bro386 ='hmc' and ah7386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da8386),count(da8386),sysdate from pw38600p
where bro386 ='hmc' and ah8386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da9386),count(da9386),sysdate from pw38600p
where bro386 ='hmc' and ah9386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da0386),count(da0386),sysdate from pw38600p
where bro386 ='hmc' and ah0386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da1386),count(da1386),sysdate from pw38600p
where bro386 ='credit' and ah1386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da2386),count(2386),sysdate from pw38600p
where bro386 ='credit' and ah2386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da3386),count(da3386),sysdate from pw38600p
where bro386 ='credit' and ah3386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da4386),count(da4386),sysdate from pw38600p
where bro386 ='credit' and ah4386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da5386),count(da5386),sysdate from pw38600p
where bro386 ='credit' and ah5386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da6386),count(da6386),sysdate from pw38600p
where bro386 ='credit' and ah6386 not like'%african bank%'
and did386 between v_start_date and v_end_date,

select bro386,sum(da7386),count(da7386),sysdate from pw38600p
where bro386 ='credit' and ah7386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da8386),count(da8386),sysdate from pw38600p
where bro386 ='credit' and ah8386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da9386),count(da9386),sysdate from pw38600p
where bro386 ='credit' and ah9386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da0386),count(da0386),sysdate from pw38600p
where bro386 ='credit' and ah0386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

- select bro386,sum(da1386),count(da1386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah1386 not like'%african bank%'
and did386 between v_start_date and v_end_date,

select bro386,sum(da2386),count(da2386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah2386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da3386),count(da3386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah3386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da4386),count(da4386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah4386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da5386),count(da5386),sysdate from pw38600p where bro386 in ('esp','licens')
and ah5386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da6386),count(da6386),sysdate from pw38600p where bro386 in ('esp','licens')
and ah6386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da7386),count(da7386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah7386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da8386),count(da8386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah8386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da9386),count(da9386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah9386 not like'%african bank%'
and did386 between v_start_date and v_end_date,

select bro386,sum(da0386),count(da0386),sysdate from pw38600p
where bro386 in ('esp','licens') and ah0386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da1386),count(da1386),sysdate from pw38600p
where bro386 ='psa' and ah1386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da2386),count(da2386),sysdate from pw38600p
where bro386 ='psa' and ah2386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da3386),count(da3386),sysdate from pw38600p
where bro386 ='psa' and ah3386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da4386),count(da4386),sysdate from pw38600p
where bro386 ='psa' and ah4386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da5386),count(da5386),sysdate from pw38600p
where bro386 ='psa' and ah5386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da6386),count(da6386),sysdate from pw38600p
where bro386 ='psa' and ah6386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

select bro386,sum(da7386),count(da7386),sysdate from pw38600p
where bro386 ='psa' and ah7386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

insert into mis_persal(brokercd,psa_8,psa_8_count,summary_date)
select bro386,sum(da8386),count(da8386),sysdate from pw38600p
where bro386 ='psa' and ah8386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

insert into mis_persal(brokercd,psa_9,psa_9_count,summary_date)
select bro386,sum(da9386),count(da9386),sysdate from pw38600p
where bro386 ='psa' and ah9386 not like'%african bank%'
and did386 between v_start_date and v_end_date;

insert into mis_persal(brokercd,psa_10,psa_10_count,summary_date)
select bro386,sum(da0386),count(da0386),sysdate from pw38600p
where bro386 ='psa' and ah0386 not like'%african bank%'
and did386 between v_start_date and v_end_date
group by bro386;

end;
/
Re: PLS-00103: Encountered [message #18403 is a reply to message #18382] Wed, 30 January 2002 06:08 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
Put a semi-colon after "mis_Persal_t(brokercd,type,loan_count,summary_date)" (just like it said in the error message). You also will have to have variables to SELECT into.
Previous Topic: how do i insert a value like 'Help'm pls' into a varchar column
Next Topic: suresh
Goto Forum:
  


Current Time: Sun Aug 09 19:05:57 CDT 2020