{"Specified cast is not valid."}

Posts   
 
    
Rishi
User
Posts: 69
Joined: 31-Oct-2011
# Posted on: 17-Dec-2011 00:00:15   

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.
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 17-Dec-2011 02:03:06   

There is no attachment simple_smile

You can use TypeConverters on your SP parameters too.

David Elizondo | LLBLGen Support Team
Rishi
User
Posts: 69
Joined: 31-Oct-2011
# Posted on: 19-Dec-2011 15:50:41   

Please See attachment.

Attachments
Filename File size Added on Approval
InvalidCast.png 89,945 19-Dec-2011 15:50.49 Approved
Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 19-Dec-2011 16:25:21   

The attached, shows an invalid cast in an Entity class, not a stored procedure. And it seems this is the PK of the Entity in question.

Which Oracle database's dataType are you using for that field?