Got a Fix? ON A 10.2.0.4 LINUX DATABASE, AN XML PROCEDURES IS RETURNING NULL VALUES

Scenario: We are sending information between Appro Loan Center and OSI via the OSI CMC Interface application. A connection is made to OSI to retrieve data to verify account existence so that the XML file can be populated with authentication and account data from Appro to be sent over to OSI.  
How process should work:Appro asks for permission to connect to OSI and verify if an account exists  OSI sends information to the appro call letting it know if the account exists or not. If so Appro sends the XML file. If not Appro creates the account, with permission from OSI, and sends the XML file over.
Scenario:  Appro asks for permission to connect and connects
Issue: OSI does not send a response

ISSUE Enviornment:
Oracle Server - Enterprise Edition
Linux x86

Findings: The issue is due to the following:
 ON A 10.2.0.4 LINUX DATABASE, AN XML PROCEDURES IS RETURNING NULL VALUES.
The same code returns valid data on a 10.2.0.2 database. Is there a known bug and fix for this issue?
Can SOMEBODY please help me? This critical issue has my project at a standstill. I cannot perform testing if the systems are unable to communicate with each other.


On a 10.2.0.4 Linux database, an XML procedures is returning null values. The same code returns valid data on a 10.2.0.2 database. Is there a known bug and fix for this issue?

### List the exact error messages and message text: ###
DECLARE

out_ERRORNBR NUMBER;
out_ERRORMSG VARCHAR2(200);
out_ORAERRORMSG VARCHAR2(200);
out_XML CLOB;
idx integer;
len integer;
Lenb integer;

XMLin CLOB := '<Transaction commitRollbackYN="N">
<Input>
<UserAuthentication connectId="1" authTyp="2">
<UserId>JMARINO</UserId>
<Passwd></Passwd>
<ApplNbr>7726</ApplNbr>
<PhysAddr>001560c71cfa</PhysAddr>
<NtwkNodeName>4548A</NtwkNodeName>
</UserAuthentication>

<Requests>
<Request reqNbr="1" reqTypCd="7711">
<Person persNbr="1" memberNbr="" taxId=""/>
</Request>
</Requests>
</Input>
</Transaction>';

BEGIN
PACK_Core_API_Main.Proc_Core_Api_Main(XMLin, out_XML);
DBMS_OUTPUT.PUT_LINE(to_char(SYSDATE, 'mm/dd/yyyy hh:mi:ss PM'));
DBMS_OUTPUT.PUT_LINE('XML in ....');
idx := 1;
len := length(XMLin);
Lenb := mod(len, 200);
while idx <=Len Loop
dbms_output.put_line(SUBSTR(XMLin,idx,200));
idx := idx + 200 ;
end loop;
DBMS_OUTPUT.PUT_LINE('----------------------------------------------------------
-------------------------------------------');

DBMS_OUTPUT.PUT_LINE('XML out ....');
idx := 1;
len := length(out_XML);
Lenb := mod(len, 200);
while idx <=Len Loop
dbms_output.put_line(SUBSTR(out_XML,idx,200));
idx := idx + 200 ;
end loop;
DBMS_OUTPUT.PUT_LINE('----------------------------------------------------------
-------------------------------------------');
END;Start Free Trial