ORA-19011: Character string buffer too small
If there's anyone who can understand my frustration and help me out a bit, I'll be indebted.
So here I am, with a perfectly running query from MS SQL Server, and the same query converted to Oracle syntax just crashes.
Research indicated that Oracle's handling of xml has a limit of 4000 characters (varchar2(4000)). [4000 characters in a tag, and no greater].
Now, just WTF's this s***?
MS SQL Server:
select acct_no "acct", acct_name "acctname" from account where company_id = 578 for xmlpath ('a'), root ('GetFinal')
Oracle:
select xmlelement("GetFinal", xmlagg(xmlelement("a", xmlelement("acct", acct_no), xmlelement("acctname", acct_name)))) from account where company_id = 578
Why the F does something so simple to obtain in other databases, require one to run around loops ten f**** million times when it comes to Oracle?????