Re: Something wrong with the script

From: <rohityogi_at_yahoo.com>
Date: 15 May 2006 14:14:27 -0700
Message-ID: <1147727667.797968.230430@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 Received on Mon May 15 2006 - 16:14:27 CDT