Hi,
I have created entities from SQL Server and then connected to Oracle and bind every entity manually. I have used type converter to handle different data type in oracle and sql server.
I dont know how to handle type cast when you are trying to connect store procedure. I have my own implementation for store procedure as i have different no. of parameters. I am getting following error. Please see the attachments.