Help with SAX Parser Error

[markangelo_dihiansan]

Hi! I'd like to ask help regarding a SAX Parser Error Problem:

There are four tables that needs to be modified, let's say

Table A (Header Table)

Table AA (Info Table)

Table B (Header Table)

Table BB (Info Table)

So far, inserting into the four tables have not been a problem. However, when deleting entries from the table, table AA and table BB completes the delete while there is no deletion performed in table A and table B. Instead, table A and table B returns a SAX Parser Error, how can this be? We've checked the SQL statement used and there are no special characters retrieved by the command and yet it still generates a Parser Error.

Points will be rewarded.

Thanks

[VijayKonam · Accepted solution]

Hi,

Are you talking about R3 tables or any other database tables? Where r u performing this? In mapping or in ABAP code? Details would be appreciated.. if possible the queries too..!!

VJ

[markangelo_dihiansan]

There were special characters in the XML, we used double-escape to helped troubleshoot the issue.

[markangelo_dihiansan]

Hi VJ! I'm talking about other database tables. The query is incorporated as a UDF (user-defined function) in a message mapping. The query is a standard SQL Database query that returns values that has no special characters in it, and yet the parser error occurs. This is very weird because when the SQL Query statement is done manually, the statement is valid. Please help, points will be awarded

Edited by: dspboys on Jul 3, 2008 10:47 AM