Skip to Main Content

Database Software

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!

DUMMY in result of XML

KP_2Aug 6 2024 — edited Aug 6 2024

Well I have just migrated old database ( and old application) from 11.2.0.4 to 19.23.0.0. The application is almost as old as me ;) so no chance to do any modification of it. Generally most of functions works , sometimes even better except …. some xmls .
Now I am analyzing what is calling what but result of procedure in package in 11.2.0.4 is:

<ChResAns>
<TrId>33071604</TrId>
<Date>05/08/2024</Date>
</ChResAns>

but in 19.23.0.0:

<ChResAns>
<DUMMY/>
<BssError/>
<TrId>33071604</TrId>
<Date>05/08/2024</Date>
</ChResAns>

So an empty tag <BssError> has been added with DUMMY value :( If course this implies some further consequences in application flow etc. etc.
Is it possible to avoid printing empty tags in Oracle19 ?

I found a bug (31895670) which is similar to my case but in my version patch for it has been already applied

any hints are welcome

thanks in advance

K.

Comments
Post Details
Added on Aug 6 2024
1 comment
122 views