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.
mapped stored procedures disappear
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
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