-
PL/SQL: ORA-00984: column not allowed here
A system administrator for one of our apps is performing an upgrade. One of the steps in the upgrade runs a script that bombs out. The error he recieves is :
ERROR at line 29:
ORA-06550: line 29, column 7:
PLS-00302: component 'MCFUQTIMEOUT' must be declared
ORA-06550: line 29, column 7:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 8, column 1:
PL/SQL: SQL Statement ignored
Here is the section of the script giving him the problem
16:13:31 SQL> DECLARE CURSOR TEMP_CURSOR IS
16:13:31 2 SELECT * FROM PS_MCFUQTIMEOUT ;
16:13:31 3 P TEMP_CURSOR%ROWTYPE ;
16:13:31 4 BEGIN
16:13:31 5 OPEN TEMP_CURSOR ;
16:13:31 6 LOOP FETCH TEMP_CURSOR INTO P ;
16:13:31 7 EXIT WHEN TEMP_CURSOR%NOTFOUND ;
16:13:31 8 INSERT INTO PSYMCFUQTIMEOUT (
16:13:31 9 MCFUQTASKNUM,
16:13:31 10 MCFUQINSERTTIME,
16:13:31 11 MCFUQATIMEOUT,
16:13:31 12 MCFUQTASKTYPE,
16:13:31 13 MCFUQQUEUEID,
16:13:31 14 MCFUQQUEUETIME,
16:13:31 15 MCFUQORIGQTIME,
16:13:31 16 MCFUQAGENTID,
16:13:31 17 LANGUAGE_CD,
16:13:31 18 MCFUQCOST,
16:13:31 19 MCFUQPRIORITY,
16:13:31 20 MCFUQSKILLLEVEL,
16:13:31 21 MCFUQCTIMEOUT,
16:13:31 22 MCFUQREASON,
16:13:31 23 MCFTASKISCLOSED,
16:13:31 24 MCFCOMMENTS,
16:13:31 25 MCFUQAPPDATA)
16:13:31 26 VALUES
16:13:31 27 (P.MCFUQTASKNUM,
16:13:31 28 P.MCFUQTIMEOUT,
16:13:31 29 P.MCFUQTIMEOUT,
16:13:31 30 P.MCFUQTASKTYPE,
16:13:31 31 P.MCFUQQUEUEID,
16:13:31 32 P.MCFUQQUEUETIME,
16:13:31 33 P.MCFUQQUEUETIME,
16:13:31 34 P.MCFUQAGENTID,
16:13:31 35 P.LANGUAGE_CD,
16:13:31 36 P.MCFUQCOST,
16:13:31 37 P.MCFUQPRIORITY,
16:13:31 38 P.MCFUQSKILLLEVEL,
16:13:31 39 P.MCFUQCTIMEOUT,
16:13:31 40 P.MCFUQREASON,
16:13:31 41 P.MCFTASKISCLOSED,
16:13:31 42 P.MCFCOMMENTS,
16:13:31 43 P.MCFUQAPPDATA)
16:13:31 44 ;
16:13:31 45 COMMIT ;
16:13:31 46
16:13:31 47 END LOOP ;
16:13:31 48 CLOSE TEMP_CURSOR ;
16:13:31 49 END ;
16:13:31 50 /
P.MCFUQTIMEOUT,
Any advice would be greatly appreciated.
-
You should make that an implicit cursor. You should also move the commit outside of the loop. Is MCFUQTIMEOUT a valid column in the PS_MCFUQTIMEOUT table/view/synonym?
-
Seems like a straight insert would be appropriate here.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|