Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00984: column not allowed here (Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production)
ORA-00984: column not allowed here [message #314223] Wed, 16 April 2008 02:05 Go to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
please can someone tell me how to resolve this error

12:21:33 PM  [375:54] PL/SQL: ORA-00984: column not allowed here


    insert into adm.alert_error_log(error_text,log_date)
    values('Error in Populating Workbook for GATE Memo '||c1_rec.memo_type||'Proj= '||c1_rec.project||'Act='||c1_rec.activity||' '||errtext,sysdate);

this is the desc of the table.
*** SCRIPT START :  Session:JAGANNK1@ARTMDV.BDC3PROJ.CO.IN(1)   4/16/2008 12:23:46 PM *** 
Processing ...
desc adm.alert_error_log
Describing adm.alert_error_log....
NAME                            Null?     Type
------------------------------- --------- -----
EMAIL                                     VARCHAR2(2000)
ERROR_TEXT                                VARCHAR2(2000)
LOG_DATE                                  DATE
*** SCRIPT END :  Session:JAGANNK1@ARTMDV.BDC3PROJ.CO.IN(1)   4/16/2008 12:23:47 PM *** 
Re: ORA-00984: column not allowed here [message #314224 is a reply to message #314223] Wed, 16 April 2008 02:06 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm guessing it's something to do with either c1_rec.memo_type or c1_rec.activity.
Are they both defined at that point?
Re: ORA-00984: column not allowed here [message #314225 is a reply to message #314224] Wed, 16 April 2008 02:11 Go to previous messageGo to next message
NewLife
Messages: 170
Registered: April 2008
Senior Member
begin
for c1_rec in c1
loop
-- do some processing here and then
exception when others then
    errtext := sqlerrm;
    insert into adm.alert_error_log(error_text,log_date)
    values('Error in Populating Workbook for GATE Memo '||c1_rec.memo_type||'Proj= '||c1_rec.project||'Act='||c1_rec.activity||' '||errtext,sysdate);


so i am trying to put the entries from the cursor into the error log, if there are any exceptions.

The cursor c1 is defined in the begining of this procedure
Re: ORA-00984: column not allowed here [message #314226 is a reply to message #314225] Wed, 16 April 2008 02:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
c1_rec is only defined as long as you are in the cursor loop.
icon10.gif  Re: ORA-00984: column not allowed here [message #314229 is a reply to message #314226] Wed, 16 April 2008 02:19 Go to previous message
NewLife
Messages: 170
Registered: April 2008
Senior Member
Hey cool buddy, thanks a ton Smile Smile
Previous Topic: please suggest a sql statement
Next Topic: how to add hour and minute
Goto Forum:
  


Current Time: Wed Dec 07 16:50:25 CST 2016

Total time taken to generate the page: 0.14179 seconds