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
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
LVL 77

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 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 35210041
If you want to UPDATE a column, it sort of has to exist first...
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 35210053
Tks I will add the column
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?

Author Closing Comment

ID: 35210333

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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 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

763 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