Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Something wrong with the script
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 SELECT BAN INTO t_BAN FROM SERVICE_AGREEMENT WHERE BAN = copps_rec.BAN; END;
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
![]() |
![]() |