The Entity Model doesn't always generate a complex type for procedures

[hom_rcp]

I have Entity Model version: 7.0.25.0. I'm facing a problem when adding a procedure that returns sys_refcursor, the Entity Model doesn't always generate a complex type.

This's the deceleration of my procedure:

Code: Select all

procedure get_items (p_user_id in number, rec_out out sys_refcursor) ;

Any help!

[Shalex]

Could you please post here or send us a body of your get_items procedure and the DDL script of the related database objects so that we can reproduce the issue in our environment?

[Shalex]

Does the problem with generating a complex type persist when you are drag&drop-ing stored procedure on the diagram surface from the Store part of Model Explorer or from Database Explorer?