Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Something wrong with the script
<rohityogi_at_yahoo.com> wrote in message
news:1147727667.797968.230430_at_j73g2000cwa.googlegroups.com...
> I added a / at the end of the script at line11 as you said but still
> the same
>
> DECLARE
> t_BAN SERVICE_AGREEMENT.BAN%type;
>
> CURSOR copps_cursor IS
> SELECT
> BAN,
> PRODUCT_TYPE,
> PRODUCT_ID,
> PRICE_PLAN,
> PP_SEQ_NO,
> EXPIRATION_DATE
> FROM
> CREDIT_PP;
> BEGIN
> FOR copps_rec IN copps_cursor LOOP
> BEGIN
> SELECT BAN INTO t_BAN FROM SERVICE_AGREEMENT WHERE BAN =
> copps_rec.BAN;
> END;
> END LOOP;
> END;
> a/
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> With the Partitioning option
> JServer Release 9.2.0.5.0 - Production
>
> SQL> @1.sql
> 12
>
Type the "/" on the line where the 12 is. Received on Mon May 15 2006 - 16:25:06 CDT