joaotelles
asked on
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_a ds.dwndata );
offset := 1;
dbms_lob.read(rec_w_ads.dw ndata, blob_size, offset, long_raw);
UPDATE W_ApplicaoadStatus
SET dwndata2 = long_raw
WHERE CURRENT OF cur_w_ads;
END LOOP;
Tks
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_a
offset := 1;
dbms_lob.read(rec_w_ads.dw
UPDATE W_ApplicaoadStatus
SET dwndata2 = long_raw
WHERE CURRENT OF cur_w_ads;
END LOOP;
Tks
Describe the table W_ApplicaoadStatus and see if it has a column called dwndata2.
ASKER
No there isnt.
How could I create it?
How could I create it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks I will add the column
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?
alter table W_ApplicaoadStatus add dwndata2 XXX;
where XXX is the data type and precision. What data type is this going to be?
ASKER
Tks