Solved

Oracle error - ORA-00904

Posted on 2011-03-24
6
1,309 Views
Last Modified: 2012-05-11
Hi,

I getting the following error:

                   PL/SQL: ORA-00904: "DWNDATA2": invalid identifier
                   ORA-06550: line 21, column 7:
                   PL/SQL: SQL Statement ignored

FOR rec_w_ads IN cur_w_ads LOOP
                 blob_size := dbms_lob.getlength(rec_w_ads.dwndata);
                 offset := 1;
                 dbms_lob.read(rec_w_ads.dwndata, blob_size, offset, long_raw);
                 UPDATE W_ApplicaoadStatus
                   SET dwndata2 = long_raw
                   WHERE CURRENT OF cur_w_ads;
               END LOOP;

Tks
0
Comment
Question by:joaotelles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35209996
Describe the table W_ApplicaoadStatus and see if it has a column called dwndata2.
0
 

Author Comment

by:joaotelles
ID: 35210024
No there isnt.

How could I create it?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 35210041
If you want to UPDATE a column, it sort of has to exist first...
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:joaotelles
ID: 35210053
Tks I will add the column
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35210057
If you really want to add a new column to the table:

alter table W_ApplicaoadStatus add dwndata2 XXX;

where XXX is the data type and precision.  What data type is this going to be?
0
 

Author Closing Comment

by:joaotelles
ID: 35210333
Tks
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to recover a database from a user managed backup
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question