Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Something wrong with the script

Something wrong with the script

From: <rohityogi_at_yahoo.com>
Date: 15 May 2006 12:07:48 -0700
Message-ID: <1147720068.934338.312760@y43g2000cwc.googlegroups.com>


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 Received on Mon May 15 2006 - 14:07:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US