Re: Something wrong with the script

On 15 May 2006 12:07:48 -0700, rohityogi_at_yahoo.com wrote:

>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;
>
>
>I have this script (1.sql) . but when I execute this script I get no
>error but instead it halts on the sql prompt
>
>This is what happens:
>
>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
> 11
>
>
>
>Can anyone suggest what is wrong with this script. Thanks a lot in
>advance.
>
>regards
>Yogi

There is nothing wrong with the script, apart from that END; delimits the BEGIN END; block. It doesn't delimit the script On line 11 you need to type a /

--
Sybrand Bakker, Senior Oracle DBA