Print Page | Close Window

"Schema Not Found" message when trying to create a Stored Procedure backed business object

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=279
Printed Date: 26-Apr-2025 at 10:21pm


Topic: "Schema Not Found" message when trying to create a Stored Procedure backed business object
Posted By: Customer
Subject: "Schema Not Found" message when trying to create a Stored Procedure backed business object
Date Posted: 16-Jul-2007 at 12:41pm
I went through your presentation called  http://www.ideablade.com/Webinars/AggregateStoredProcedures/Video/AggregateStoredProcedures.html - Object-Relational Stored Procedures for Aggregate Entities .   This appeared to be exactly what I was looking for.  It probably is, except I continue to receive this error:
  
Is there something that I need to do within the stored procedure to explicitly state the schema?  Your demo made it look easy.  If you could set me on the right track, I would appreciate it.
 


Replies:
Posted By: IdeaBlade
Date Posted: 16-Jul-2007 at 12:51pm
I believe that the root cause here is that you are using temporary tables which is confusing to the Object Mapper.
 
Fortunately, there is an easy workaround:
 
Just comment out the relevant sections of the stored pocedure that create and reference the temporary table(s), then use the OM to create the business object.  Finally, you can go back to the database, and take out your comments.  Everything will work as it should.  Of course, every time you go back to the OM to edit/create stored procedure-backed business objects, you must again comment out the sections that acccess the temporary tables.
 
An alternative workaround is to use any "dummy" stored procedure that has the correct input and output columns. After mapping has succeeded, replace the "dummy" stored procedure with the real one. 


Print Page | Close Window