I am trying to create a dsp library procedure from a database procedure.
The database procedure takes a boolean as input parameter. But when i try to create a dsp procedure it interprets the boolean as xs:integer.
(::pragma function <f:function xmlns:f="urn:annotations.ld.bea.com" visibility="public" kind="library" isPrimary="false" nativeName="VALIDATE" nativeLevel2Container="xxx" style="storedProcedure">
<nonCacheable/>
<params xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xdt="http://www.w3.org/2004/07/xpath-datatypes" >
<param name="VALUE" kind="in" xqueryType="xs:string" nativeTypeCode="12" nativeType="VARCHAR2"/>
<param name="GETERROR" kind="in" xqueryType="xs:integer" nativeTypeCode="4" nativeType="PL/SQL BOOLEAN"/>
<param name="ERROR" kind="inout" xqueryType="xs:string" nativeTypeCode="12" nativeType="VARCHAR2"/>
</params>
</f:function>::)
When I run this procedure to test it,(The value I passed for 'GETERROR' is 0.0) it gives me the following error.
weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_4974007978ca02ad:77f319f6:11fb9874a82:-7fda): java.lang.RuntimeException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'VALIDATE_ELEMENT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Then i modified the xs:integer to xs:boolean , (The value I passed for 'GETERROR' is 'true'), then the error is:
weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_4974007978ca02ad:77f319f6:11fb9874a82:-7fd9): weblogic.xml.query.exceptions.XQueryTypeException: {bea-err}TYPE003: Runtime Type Mismatch
Is there any known problem in DSP for PL/SQL BOOLEAN when we try to interpret to create a library procedure?.
Thanks