Hi there,
I am having an issue because I don’t know how to poll a function in oracle using the brand new WCF-OracleDB.
So I created using Visual Studio the schemas corresponding to my SQL Function.
– Service_OracleDBBindingICISF.Function.xsd
– Service_OracleDBBindingICISF.PollingFunction.xsd
– Service_OracleDBBindingICISF.UserType.xsd
In the Receive location I specified the following :
PollingAction : http://Microsoft.LobServices.OracleDB/2007/03/xxx/PollingFunction/DEQUEUE_AQ_QUEUE
Poling Statement : <DEQUEUE_AQ_QUEUE xmlns=”http://Microsoft.LobServices.OracleDB/2007/03/xxxx/Function” />
If the function returns nothing then, I got this xml as output <DEQUEUE_AQ_QUEUE xmlns=”http://Microsoft.LobServices.OracleDB/2007/03/ICISF/PollingFunction“ />
If the function returns values then I got this exception :
“WCF-OracleDB” … details “System.InvalidOperationException: Correspondance of personal types for ‘dataSource=’xxx’ schemaName=’xxx’ typeName=’AQ_TYPE” non spécifiée ou non valide.
Any help on this?
Regards,
Stefan
http://www.itsconsulting.fr
http://www.elbeb.com