Devart Forums

When bringing an Oracle stored procedure into the entity model, number and integer types are mapped to type decimal. This is problematic when attempting to map a stored procedures for INSERT, UPDATE, etc. functions on an entity. It makes it impossible to designate a column as the "Rows Affected" parameter as the designer will only recognize integer types for that purpose. Manually changing the types in the XML causes issues with the designer. Are there any ways to control, or otherwise modify, data types once a function import has been established?

I'm attepting to add a stored procedure to an EF4 entity model. This particular procedure has a number of parameters that are arrays. They are defined as:

TYPE array_ IS TABLE OF .%TYPE
INDEX BY BINARY_INTEGER;

Please note that I'm replacing some actual code with a generic value in the code examples.

When attepting to include this procedure in the model, the designer identifies the following error(s)

"The function . has a parameter 'IN_' at parameter index nn that has a data type 'PL/SQL TABLE' which is not supported. The function was excluded."

I did read the FAQ page, but it it doesn't clearly state what to do regarding this issue. What is the workaround... if any... for this?

Thanks !!