It may help to see the procedure you've wrapped it in- or a section at least? Steve arul.kumar@xxxxxx wrote: >Gurus, > >Sorry for posting a pl/sql problem.=20 > >I have this following UPDATE in a flat sql file. When I try to wrap it >up in a stored procedure reports compilation error at "+" sign saying >that something is missing!? > > >update BREEZE_HOUR_VOLUME set > COMPLETED =3D COMPLETED + > (select count(*) from >cust_orders@xxxxxxxxxxxxxxxxxxxxxxxxx > where status =3D 'COMPLETE' > and id in > (select cust_order_id from >cust_order_lines@xxxxxxxxxxxxxxxxxxxxxxxxx > where substr(execution_time,1,10) >=3D to_char(trunc(ld_start_date) -1/24, 'YYYYMMDDHH24') > ) > ) >where CREATION_HOUR =3D 00 > and CREATION_DATE =3D trunc(ld_start_date) > and SITE =3D 'B'; > > >Any clues / suggestions? > >Have a nice day! > >Thanks, > -- //www.freelists.org/webpage/oracle-l