SQL*Plus (MOSC)

MOSC Banner

Using the DBMS_XMLGEN.GETXML package in R12 verse 11i.

edited Oct 30, 2012 9:51AM in SQL*Plus (MOSC) 3 commentsAnswered ✓
Hello All,
I have noticed that for some Oracle Reports in R12 that the first line of the XML file has the following:

<?xml version="1.0" encoding="UTF-8" ?>

The following query only has this as the first line in the XML file:
<?xml version="1.0"?>
SELECT DBMS_XMLGEN.GETXML ('select * from mtl_system_items_b') XML from dual; /

My question is how can I get it to put the encoding portion in there?

Thanks,
Chris

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