mapped stored procedures disappear

robymes · Post by **robymes** » Fri 09 Jan 2009 11:36

Hello,
I have a problem with stored procedures: every time I update model from database, they disappear from the model, no matter if there's a modification in the db schema or not.
I have to manually edit the xml to include both the functions ad the mapping, and it's very annoying.
This kind of behaviour is not present if I use SQL Server (I'm mapping the same schema db both form Oracle and SQL Server).
I'm using the latest build of dotConnect for Oracle (5.00.16).
Thanks.

AndreyR · Post by **AndreyR** » Fri 09 Jan 2009 14:43

Could you please send us your DB objects definitions? That can help to reproduce the problem (so far I can't reproduce it).

robymes · Post by **robymes** » Fri 09 Jan 2009 16:52

Thanks,
where I can provide you sql scripts?

AndreyR · Post by **AndreyR** » Mon 12 Jan 2009 08:39

You can send scripts to the email provided in my profile (andreyr * devart * com)

robymes · Post by **robymes** » Mon 12 Jan 2009 13:55

Hello,
I understand why the SP disappeared: I took a look into the xml of edmx file and I found:

Errors Found During Generation: warning 6005: The function 'CREATESECTION' has a parameter 'V_MENUVISIBILITY' at parameter index 5 that has a data type 'PL/SQL BOOLEAN' which is not supported, the function was excluded.

I have to say:
first, BOOLEAN is perfectly legal in PL\SQL, even if there's no such data type name for table fields, boolean in table fields must be NUMBER(1,0)
second, the SP mapped for CRUD, with BOOLEAN in parameters, works perfectly with your data provider for EF, so I don't understand why the designer alerts an error this way.

thanks

AndreyR · Post by **AndreyR** » Mon 12 Jan 2009 14:55

We have made a significant number of fixes in the upcoming build, including the one associated with PL/SQL Boolean in stored procedures.