I saw "the" in aSQL from java code and I thought it was a mistake, but it wasn't:
>select eamrid, action_code, fault_msg, execution_time, timeout_value
2 from ( select cast( pkg_ode.parse_response('METERREADINGS', '1.4', :v_xml ) as odeXML ) from dual ) a;
select eamrid, action_code, fault_msg, execution_time, timeout_value
*
ERROR at line 1:
ORA-00904: "TIMEOUT_VALUE": invalid identifier
>select eamrid, action_code, fault_msg, execution_time, timeout_value
2 from the ( select cast( pkg_ode.parse_response('METERREADINGS', '1.4', :v_xml ) as odeXML ) from dual ) a;
EAMRID ACTION_CODE FAULT_MSG EXECUTION_TIME TIMEOUT_VALUE
---------- -------------------------------------------------- ---------- ----------------- -------------
46 RESPONDED {n} {n} 0
Is "the" a keyword or do something special? I couldn't find it listed anywhere in Oracle docs as one and searching the web for it is pretty useless, but I tried.
Thanks,
Steve