Andrus,
This issue is somewhat related to Brian's issue before. There are actually a couple issues that we are having with stored procedures. The one Brian mentions of the run time errors we are getting when there are stored procedures to load. In the *.map.xml file we do see the <procedure>....</procedure> sections for each procedure. From what I can tell they look okay. We have quite a number of procedures. Here's just a snippet of what we have.
<procedure name="AADBMS_LAST_ROWID" schema="MEMBERSHIP" returningValue="true">
<procedure-parameter name="_return_value" type="VARCHAR" direction="out"/>
</procedure>
<procedure name="ACTIVE_MEM_FOR_SENDING_EMAIL" schema="MEMBERSHIP" catalog="EMAIL_PREF_PKG" returningValue="true">
<procedure-parameter name="_return_value" type="DECIMAL" length="22" direction="out"/>
<procedure-parameter name="I_PERSON_ID" type="DECIMAL" length="22" direction="in"/>
</procedure>
<procedure name="ACTIVE_MEM_FOR_VIEWING_PREFS" schema="MEMBERSHIP" catalog="EMAIL_PREF_PKG" returningValue="true">
<procedure-parameter name="_return_value" type="DECIMAL" length="22" direction="out"/>
<procedure-parameter name="I_PERSON_ID" type="DECIMAL" length="22" direction="in"/>
</procedure>
<procedure name="CALCULATE_REN_RATES" schema="MEMBERSHIP" catalog="RRENGINE">
<procedure-parameter name="I_WE_DT" type="TIMESTAMP" direction="in"/>
</procedure>
<procedure name="COMPLETED" schema="MEMBERSHIP" catalog="PGMEVTS" returningValue="true">
<procedure-parameter name="_return_value" type="VARCHAR" direction="out"/>
</procedure>
The other issue which is the one I was asking about is regarding the view of the procedures in the Modeler. If we create a procedure through the Modeler directly, then we can see it listed under the DbEntities with the icon you mentioned. However, the procedures that are created through the ReEngineering function of the modeler do not show up under the DbEntities. The only way we can see what procedures are loaded is through the *map.xml file.
Beth
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Wednesday, November 03, 2004 5:55 PM
To: cayenne-use..bjectstyle.org
Subject: Re: Where are Stored Procedures in Modeler
Beth,
Is this something related to the stored procedure problems mentioned by
Brian?
http://objectstyle.org/cayenne/lists/cayenne-user/2004/10/0147.html
Stored procedures in the Modeler are displayed under DbEntities using
this icon -
http://objectstyle.org/cayenne/images/modeler/icon-stored-procedure.gif
Another thing to check is the XML stored in *.map.xml after you save a
map with stored procedures. It should contain them as
<procedure>...</procedure> sections. If they are there, but there is a
problem with loading them back, please open a bug report and attach
your *.map.xml file, so that the problem can be reproduced.
Andrus
On Nov 3, 2004, at 4:45 PM, Williams, Beth wrote:
> This seems like a very simple question and I'm probably just
> overlooking it, but how can the Stored Procedures be seen in the
> Modeler? I have gone through the process to reengineer a db table and
> specify Load Procedures. When I do a Validate Project, I get some
> errors that pop up saying ProcedureParameter has no direction. When I
> click on each error, the procedure is displayed with two tabs
> (Procedure and Parameters). But once I fix all the errors I have not
> found a way to get back to the Prodcedures in the Modeler. I can see
> where I can create a new procedure, but what I need to do is to view
> the ones that are already there. Any help is greatly appreciated.
> Thanks.
>
> Beth
>
This archive was generated by hypermail 2.0.0 : Thu Nov 04 2004 - 09:48:16 EST
