This discussion is archived
0 Replies Latest reply: Aug 20, 2013 7:57 AM by 981375 RSS

Error: ORA-31011 // when calling function via HTTP

981375 Newbie
Currently Being Moderated

Hello,

 

I've got a function that returns XMLType, it works fine from sqldeveloper and sqlplus but it cannot be called from a browser via http as it shows the following error:

 

El presente archivo XML no parece tener ninguna información de estilo asociada. A continuación se muestra su árbol.
<soap:Envelope>
    <soap:Body>
        <soap:Fault>
            <faultcode>soap:Client</faultcode>
            <faultstring>Error processing input</faultstring>
            <detail>
                <OracleErrors>
                    <OracleError>
                        <ErrorNumber>ORA-31011</ErrorNumber>
                        <Message>XML parsing failed</Message>
                    </OracleError>
                </OracleErrors>
            </detail>
        </soap:Fault>
    </soap:Body>
</soap:Envelope>

 

So what I did was create a simpler function that just returns a constant 'ASD' as varchar2, you can see it below:

 

 

create or replace 
FUNCTION FUNCTION2 RETURN varchar2 AS 
BEGIN
  RETURN 'ASD';
END FUNCTION2

 

I still get the same error and I've got no clue on what it could be. Any help would be truly appreciated.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points