Oracle error - ORA-00904

Posted on 2011-03-24
Last Modified: 2012-05-11

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;
       , blob_size, offset, long_raw);
                 UPDATE W_ApplicaoadStatus
                   SET dwndata2 = long_raw
                   WHERE CURRENT OF cur_w_ads;
               END LOOP;

Question by:joaotelles
  • 3
  • 3
LVL 76

Expert Comment

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

Author Comment

ID: 35210024
No there isnt.

How could I create it?
LVL 76

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 35210041
If you want to UPDATE a column, it sort of has to exist first...
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.


Author Comment

ID: 35210053
Tks I will add the column
LVL 76

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?

Author Closing Comment

ID: 35210333

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
querying by the sum of a column in decimal 7 57
Convert Oracle data into XML document 2 59
Oracle -- identify blocking session 24 43
Oracle sql query 7 49
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now