Devart Forums

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.

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

Thanks,
where I can provide you sql scripts?

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

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

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