Oracle error - ORA-00904

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
joaotellesAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
If you want to UPDATE a column, it sort of has to exist first...
0
 
slightwv (䄆 Netminder) Commented:
Describe the table W_ApplicaoadStatus and see if it has a column called dwndata2.
0
 
joaotellesAuthor Commented:
No there isnt.

How could I create it?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
joaotellesAuthor Commented:
Tks I will add the column
0
 
slightwv (䄆 Netminder) Commented:
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
 
joaotellesAuthor Commented:
Tks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.