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

On 15 May 2006 12:07:48 -0700, rohityogi@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

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

<rohityogi@yahoo.com> wrote in message
news:1147727667.797968.230430@j73g2000cwa.googlegr oups.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.

On 15 May 2006 14:14:27 -0700, rohityogi@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

Thanks, Dont laugh for me acting so dumb.