SQL Language (MOSC)

MOSC Banner

When SELECT from XMLTABLE isn't in XML no data is returned

I created a view against XML in a CLOB that works normally. But when what is defined in columns as an XMLTABLE doesn't exist no data is returned.

CREATE OR REPLACE VIEW ind_custom.ind_test2_amz_cxml_files_v AS
SELECT inv.invoiceID,
inv.purpose,
inv.operation,
TO_DATE(TO_CHAR(TO_TIMESTAMP_TZ(inv.invoiceDate,
'yyyy-mm-dd"T"hh24:mi:sstzhtzm') at time zone 'America/Los_Angeles',
'yyyymmdd hh24:mi:ss'),
'yyyymmdd hh24:mi:ss') AS invoiceDate,
inv.isAccountingInLine,
ipr.remitToName,
ipr.remitToStreet,
ipr.remitToCity,
ipr.remitToState,
ipr.remitToPostalCode,
ipr.remitToCountry
FROM ind_custom.ind_amz_cxml_files xf,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center