Go Premium for a chance to win a PS4. Enter to Win


Oracle error - ORA-00904

Posted on 2011-03-24
Medium Priority
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;
                 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;

Question by:joaotelles
  • 3
  • 3
LVL 78

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 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 35210041
If you want to UPDATE a column, it sort of has to exist first...
Industry Leaders: 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 78

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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) 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 shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

879 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