New Posts New Posts RSS Feed: Specified cast is not valid
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Specified cast is not valid
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
msgetiren View Drop Down
Newbie
Newbie


Joined: 10-Nov-2009
Posts: 1 		Post Options Post Options   Quote msgetiren Quote  Post ReplyReply Direct Link To This Post Topic: Specified cast is not valid
    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.
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down