Re: Something wrong with the script

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 May 2006 23:45:18 +0200
Message-ID: <uith6292ljl3jm57c8f9jnjis8em9peacv@4ax.com>

On 15 May 2006 14:14:27 -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;
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;
/

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon May 15 2006 - 16:45:18 CDT