Re: PL/SQL problem.

  • From: Steve Jelfs <steve@xxxxxxxxxxxxxx>
  • To: arul.kumar@xxxxxx
  • Date: Tue, 18 Jan 2005 09:52:58 +0000

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

Other related posts: