DevOps, CI/CD and Automation

Hi all,


I have a view as below ,


create or replace VIEW CUSTOMER_VIEW
as
select c.*
from
RECEIVABLES_TABLE,
XMLTABLE
(
'/RECEIVABLES/CUSTOMER'
passing OBJECT_VALUE
COLUMNS
CUSTOMER_NO VARCHAR2(32),
SUBSEGMENT XMLTYPE
) C
/

Here the table is a xmltype table.
This table has been changed from xmltype column to clob column . so how do i recreate the view
Creating like below is throwing error.
create or replace VIEW CUSTOMER_VIEW
as
select c.*
from
(SELECT xmltype(xml_file) FROM test_clob), --RECEIVABLES_TABLE,
XMLTABLE
(
'/RECEIVABLES/CUSTOMER'
passing OBJECT_VALUE
COLUMNS
CUSTOMER_NO VARCHAR2(32),
SUBSEGMENT XMLTYPE
) C
/

ORA-00904: "OBJECT_VALUE": invalid identifier


Is there a work around........

Thanks
Vijay g
6721