0 Replies Latest reply: Aug 20, 2013 9:57 AM by 981375 RSS

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

    981375

      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.