Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i compare two XML files storeds in a LONG column

509198Oct 4 2012 — edited Oct 5 2012
Hi,

I need to compare two xml files. My xmls are stored in two table like this:

Table 1
ID_COL number(5);
XML1 LONG()

Table 2
ID_COL number(5);
XML2 LONG()

I need compare the values of the tags of this xmls files e to list de differences.

Tks,
Fernando.

Comments

SureshDooly-Oracle

$oerr ora 12154
ORA-12154: TNS:could not resolve the connect identifier specified

Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured.
For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached.

Please cross-check the below:

Action: The following actions may be appropriate:
If you are using local naming (tnsnames.ora file):
Make sure that TNSNAMES is listed as one of the values of the names.directory_path parameter in the sqlnet.ora Oracle Net profile.
Verify that a tnsnames.ora file exists and is in the proper directory and is accessible.
Check that the net service name used as the connect identifier exists in the tnsnames.ora file.
Make sure there are no syntax errors anywhere in the tnsnames.ora file. Look for unmatched parentheses or stray characters. Errors in a tnsnames.ora file may make it unusable.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2012
Added on Oct 4 2012
#xml
10 comments
512 views