APEX

I am trying to change a VARCHAR(2) data type into a BLOB. I have researched the web and found what I thought was the solution. That was to create a new column that was a BLOB, copy the information from the column I what to modify into it, then delete the original column and rename the BLOB column to that original name.

However I am getting error messages such as…

ORA-00904: "CUSTOMER2"."Cust_Firstname": invalid identifier

When I issue this statement:

UPDATE CUSTOMER2 SET "CUSTOMER2"."Cust_Firstname"=Temp_Name;

or

ORA-00904: "CUSTOMER2"."Temp_Name": invalid identifier

When I issue this statement:

UPDATE CUSTOMER2 SET "CUSTOMER2"."Cust_Firstname"="CUSTOMER2"."Temp_Name";

Or

And I have gotten an error message saying update failed was expecting a numeric got BLOB.

I have UPDATED the table…


SQL>Alter table CUSTOMER2 ADD Temp_Name BLOB;

Table altered.

0.74 seconds



Does anyone have any ideas? All help would be very much appreciated!

-Robert