The correct dbms_xmlgen. Getxml table information-CodePudding

SQL:

 select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'

Error:

 ORA - 19202: the Error occurred in the XML processing 
ORA - 00942: a table or view does not exist 
ORA - 06512: an "SYS. DBMS_XMLGEN", line 176 
ORA - 06512: the at line 1 
19202. In 00000 - "Error occurred in the XML processing % s" 
* Cause: An error occurred when processing the XML function 
* Action: Check the given error message and fix the appropriate problem

Is not some table can, some tables, table some Settings to use getxml?

CodePudding user response:

All tips, table or view does not exist, tables, or trying to was not found, no related tables

CodePudding user response:

First, make sure you under the relevant user if there is a correlation table in the database

CodePudding user response:

refer to the second floor js14982 response:

first confirm your database under the relevant user if there is a correlation table

Table is some, I think he isn't this wrong "SYS. DBMS_XMLGEN", line 176 didn't get to the table information, or table permissions problems, but I found no bad use of the difference between table and table to use

CodePudding user response:

Find which table without first, and then directly connected to the database to check the table don't have, whether under the relevant users can query, it is possible that no permission to query the table

CodePudding user response:

Open 10046 or errstack see more detailed information

CodePudding user response:

Select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
The select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

CodePudding user response:

refer to 6th floor riven2011 response:

select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
Select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

The user name of the table the two don't know what do you mean? Are you kidding? You write SQL and I write is there a difference?

CodePudding user response:

refer to 7th floor Vicale_soFt response:

Quote: refer to the sixth floor riven2011 response:

Select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
Select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

The user name of the table the two don't know what do you mean? Are you kidding? You write SQL and I write is there a difference?

Don't thank others help you doubt dispels doubts will see, don't go to practice, such not to compare self-righteousness, ha ha

CodePudding user response:

refer to the eighth floor riven2011 response:

Quote: refer to 7th floor Vicale_soFt response:

Quote: refer to the sixth floor riven2011 response:

Select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
Select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

The user name of the table the two don't know what do you mean? Are you kidding? You write SQL and I write is there a difference?

Thank others help you will see, don't go to practice, such not to contrast becomes self-righteous hehe

That you said a meaningful answer, consult the principle,

CodePudding user response:

refer to the eighth floor riven2011 response:

Quote: refer to 7th floor Vicale_soFt response:

Quote: refer to the sixth floor riven2011 response:

Select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
Select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

The user name of the table the two don't know what do you mean? Are you kidding? You write SQL and I write is there a difference?

Thank others help you will see, don't go to practice, such not to contrast becomes self-righteous hehe

What does PROD_DEV represents what, TABLE_NAME I also look not to understand

CodePudding user response:

references 9 f Vicale_soFt response:

Quote: refer to the eighth floor riven2011 response:

Quote: refer to 7th floor Vicale_soFt response:

Quote: refer to the sixth floor riven2011 response:

Select dbms_xmlgen. Getxml (' select count (*) c from users' | | 'table name) from all_tables where the owner=' users'
Don't know what do you mean by the Chinese, give you change my can execute SQL:
Select dbms_xmlgen. Getxml (' select count (*) c from PROD_DEV. '| | TABLE_NAME) from all_tables where the owner=' PROD_DEV '

The user name of the table the two don't know what do you mean? Are you kidding? You write SQL and I write is there a difference?

Thank others help you will see, don't go to practice, such not to contrast becomes self-righteous hehe

That you said a meaningful answer, ask principle,

Do you speak your prod_dev replace your schema is not an error?
Dynamic SQL stitching is user name. The name of the table, you missed a.?

CodePudding user response:

11 references riven2011 response:

Quote: references 9 f Vicale_soFt response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull