1
$\begingroup$

Following query is returning null in Mathematica.

t = "select xmlelement(\"test\",1) as test from dual"; SQLExecute[conn, t]

It should retrun 1 as result but it is returing NUll value. How can I rertive xml data stored in the database using mathematica??

Improve this question
$\endgroup$
1
  • $\begingroup$ You might try casting the XML to varchar, e.g. select cast(xmlelement("test",1) as varchar(255)) as test from dual. $\endgroup$ Commented May 24, 2017 at 14:16

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.