Stack Overflow
Stack Overflow

Questions tagged [dbms-xmlgen]

15 questions
4
votes
2 answers

Oracle problems with dbms_xmlgen package

I have a weird problem with dbms_xmlgen package in Oracle 10g. Here's my situation: Queries using this package usually work as expected, without issues. I.E.: SQL> select dbms_xmlgen.getXML('select 1 from dual') from…
Pablo Santa Cruz
  • 176,835
  • 32
  • 241
  • 292
2
votes
1 answer

Extractvalue from XML using XML compliant format in Oracle SQL

I have a requirement . I need to query a table and display the column value by transforming escape character into XML format example " & " to "&" Details I have table name "AppName" select NAME from AppName NAME --------- Oracle &…
lkv
  • 69
  • 1
  • 8
1
vote
1 answer

Unable to query multiple tables via XML: Error occurred in XML processing

I would like to get a column_name and table_name for a list from all_tab_columns (which is not a problem till here) and also for each given column I want to go to the original table/column and see what is the top value with highest occurence. With…
FBR
  • 25
  • 6
1
vote
1 answer

SQL data extracts works in Oracle 11g but not Oracle 12c

When I execute the following SQL using TOAD against an Oracle 11g database, the fully formed XML is returned successfully: With T As (SELECT dbms_xmlgen.getxml('SELECT m.trans_message FROM xml_nodes_ams_in a, message m WHERE a.id = m.msg_id AND…
Luke_Skywalker007
  • 117
  • 1
  • 13
1
vote
1 answer

DBMS_XMLGEN package limitations?

I need to get a XML from the returning of a complex query. My previous examples in similar situations, I've used the DBMS_XMLGEN package context tyo generate the XML. But in this example, I have a problem: ... begin l_ctx := …
milheiros
  • 621
  • 2
  • 14
  • 34
0
votes
1 answer

Generating XML data from a row value having multiline data

I need one help in SQL to generate XML file. I have one table which has one column with multiline row data. Table Name: table1 Column Name: col1 1 Row Data is like below: VALUE1 VALUE2 VALUE3 VALUE4 I need to generate below XML file. …
Biswanath Misra
  • 1
  • 2
0
votes
1 answer

Count of rows from all views in Oracle with a condition

I am trying to get count of all rows from views in oracle schema and my code is working fine. But when i try to add a condition like where actv_ind = 'Y', i am unable to get it working. Any suggestions on how to modify the code to make it…
Arun.K
  • 103
  • 2
  • 4
  • 21
0
votes
1 answer

How to query a specific number of rows in order to avoid buffer overflow when spooling XML result

I have a script that runs a sqlplus command in order to generate a XML result and spool it to a file. Everything goes well except when I do it on a big table. A buffer overflow exception is raised when I get a clob greater than 1000000 bytes... I am…
Wallarou
  • 63
  • 1
  • 7
0
votes
1 answer

dbms_xmlgen.getxml showing null output in Oracle

When I run the dbms_xmlgen.getxml funtion in SQL query separately it gives me xml output but when I run it inside procedure, it gives me the null output. Could you please let me know where the error lies? Below is the code that I run separately…
Nik
  • 204
  • 1
  • 7
  • 18
0
votes
0 answers

PL/Sql dbms_xmlgen.getxml not returning all table columns in XML output

I am trying to extract Oracle table data in XML format using the DBMS_XMLGEN.GETXMLTYPE libraries. With my SQL described below; I get the output in the format I want but XML generator skipped the last column output. It happens to be the LONG data…
user10102351
  • 1
  • 1
0
votes
1 answer

DBMS_XMLQUERY vs DBMS_XMLGEN: Any replacement for DBMS_XMLQUERY.seterrortag(sqlcontext, 'Any_Tag_Name')

Since Oracle version is upgraded. We have to replace all the existing DBMS_XMLQUERY functions to DBMS_XMLGEN. There is one function DBMS_XMLQUERY.seterrortag(sqlcontext, 'Any_Tag_Name'). We didn't get any replacement for this tag in XMLGEN. Any…
Sandeep Bhalothia
  • 13
  • 3
0
votes
1 answer

dbms_xmlgen oracle get dynamic xmltype

I have a table t in oracle: select op_id, dimorder, title from t: OP_ID|DIMORDER|TITLE -----+--------+----- 312| 1|AAA 312| 2|BBB I would like to achieve, with dbms_xmlgen.getXml this result (ONLY ONE…
Luca Di Gregorio
  • 41
  • 4
0
votes
1 answer

dbms_xmlgen.getxml statement throwing ORA-01704: string literal too long

So I have this SQL statement that I am calling within the dbms_xmlgen.getxml function and I am receiving the error ORA-01704: string literal too long. I believe the issues is that the SQL statement I am calling within the function is just too big. …
Batad
  • 15
  • 5
0
votes
1 answer

Reverse Oracle dbms_xmlgen.getxmltype() - ie can I SQL query an xmltype rowset to get back table results?

Transforming myTableWithManyColsAndRows -> myTableWithOneXmlTypeColumn as follows: declare result xmltype; begin result := dbms_xmlgen.getxmltype('select * from myTableWithManyColsAndRows') insert into table myTableWithOneXmlTypeColumn…
user1305156
  • 201
  • 1
  • 10
0
votes
2 answers

Oracle DBMS_XMLGEN.newcontextfromhierarchy (-> queryString)

I have a question and maybe someone has gone through the same problem and can help. I'm working on a project where I need to create a hierarchical XML document from hierarchical data. I have the query that pulls the data and the problem I'm facing…
sergiopuy
  • 43
  • 2
  • 10