zecompadre
New Member
I am using this query to extract the value from the xml\[code\]SELECT extractvalue(column_value, '/TransactionLimitDTO/idTxn') "TxnId"FROM TABLE(XMLSequence(XMLType(mg.limits) .extract('/ModifyTransactionLimitRequestDTO/transactionLimit/TransactionLimitDTO'))) t,Mstgloballimitspackage mg\[/code\]But here it is showing me error\[quote\] ORA-00904: "MG"."LIMITS": invalid identifier\[/quote\]Could you please tell me how can I resolve this?I tried this option\[code\] SELECT extractvalue(column_value, '/TransactionLimitDTO/idTxn') "TxnId" FROM TABLE(XMLSequence(XMLType(select mg.limits from Mstgloballimitspackage mg) .extract('/ModifyTransactionLimitRequestDTO/transactionLimit/TransactionLimitDTO'))) t\[/code\]but this is also not working.and when I put complete xml file in the place of mg.limits it is showing me too long string literal as a argument errorand it is working whenever i am putting small xml in the place of mg.limits