<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am using xmltable function within a function.<br />
I am passing the column paths as parameter.eg: 'employee1\Name\Fname'<br />
I tried using the input parameter just after path keyword in xmltable query but got error as below:<br />
<br />
PL/SQL: ORA-01780: string literal required<br />
<br />
How to make it possible to pass paths as dynamic variables ?
</div>
</div>


Hi Experts,

I am using xmltable function within a function.
I am passing the column paths as parameter.eg: 'employee1\Name\Fname'
I tried using the input parameter just after path keyword in xmltable query but got error as below:

PL/SQL: ORA-01780: string literal required

How to make it possible to pass paths as dynamic variables ?

passing path as variable parameter in xmltable

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).