Technology Stack - EBS (MOSC)

MOSC Banner

Calling Oracle Custom web Service From PHP

edited Mar 20, 2014 12:00PM in Technology Stack - EBS (MOSC) 1 commentAnswered

I am trying to call oracle consuming web service in php code igniter. In my oracle package, there is procedure. In which, I passed 2 parameters. 1st is number type and 2nd is Nested table. When i try to execute it, it gives me error like,

<span class="pln"></span><span class="str"><strong>"Uncaught SoapFault exception: [WSDL] SOAP-ERROR: Parsing Schema: **element has both</strong><br/><strong>  'type' attribute and subtype</strong></span>


Procedure :

CREATE OR REPLACE PACKAGE ORACLE_PKG_R AUTHID CURRENT_USER AS

     TYPE POSPLIT IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

     FUNCTION ACCEPTANCE(HEADER_ID IN VARCHAR2,P_NOTE IN VARCHAR2) RETURN NUMBER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center