ORA-00911:字符无效? [英] ORA-00911: invalid character?

问题描述

我遇到以下错误:

ORA-00911:XDocument doc = Document.Load(crtCommand.ExecuteScalar().ToString()); *

ORA-00911: invalid character at XDocument doc= Document.Load(crtCommand.ExecuteScalar().ToString());*

使用以下代码:

 using (OracleConnection conn1 = new OracleConnection(oradb1))
 {
     conn1.Open();

     using (OracleCommand crtCommand
         = new OracleCommand("SELECT dbms_metadata.get_sxml('VIEW','VIEW_TBL_A') FROM dual;", conn1))
     {
         XDocument doc = XDocument.Load(crtCommand.ExecuteScalar().ToString());
         XNamespace ns = "http://xmlns.oracle.com/ku";

         if (doc.Descendants(ns + "COL_LIST_ITEM").Any(c => c.Attributes().Any()))
             MessageBox.Show("COL_LIST has value");
         else 
             MessageBox.Show("COL_LIST has no value");
     }
 }

推荐答案

摆脱尾随的分号.

using (OracleCommand crtCommand = new OracleCommand(
    "SELECT dbms_metadata.get_sxml('VIEW','VIEW_TBL_A') FROM dual", conn1))

在传递单个语句以立即执行时，Oracle不喜欢语句分隔符.

Oracle doesn't like statement delimiters when passing in a single statement for immediate execution.

这篇关于ORA-00911:字符无效?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！