DevForce Community Forum : Specified cast is not valid http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Specified cast is not valid Wed, 10 Jun 2026 11:29:21 -700 Tue, 10 Nov 2009 12:28:03 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1552 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Specified cast is not valid : You will need to use the Oracle... http://www.ideablade.com/forum/forum_posts.asp?TID=1552&PID=5774#5774 Author: davidklitzke
Subject: 1552
Posted: 10-Nov-2009 at 12:28pm

You will need to use the Oracle Native Provider.  See Developer's Guide around page 229.

Oracle Stored Procedure Queries

We can map a business object directly to a Microsoft SQL Server stored procedure but we cannot map a business object to an Oracle stored procedure because the Object Mapping tool cannot discover the schema for Oracle stored procedures.

Fortunately, we can use an Oracle stored procedure to return business objects by invoking that procedure in a Stored Procedure Query. The target business object can be any entity resulting from the Object Mapping exercise.

If there is no such entity, we can manufacture a "Fictive Entity Class" as described earlier in this section.

Querying Example

DevForce supports Oracle stored procedures via Oracle Ref Cursors. An example stored procedure and its corresponding DevForce code follow

]]> Tue, 10 Nov 2009 12:28:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1552&PID=5774#5774 Specified cast is not valid : Hi,I have a problem. I use Oracle... http://www.ideablade.com/forum/forum_posts.asp?TID=1552&PID=5768#5768 Author: msgetiren
Subject: 1552
Posted: 10-Nov-2009 at 1:55am

Hi,
I have a problem. I use Oracle DB so that, I used Microsoft OLE DB Provider For Oracle. When I try to add class from unmapped classes and stored procedures' form, it gives me an error:"Specified cast is not valid". How can I fix this problem.
]]> Tue, 10 Nov 2009 01:55:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1552&PID=5768#5768