Custom Tool Error. TYPE Table is not qualified with namespace or Alias

[rednose84]

Hi @all

i have an function in opracle that will return an "table".

Code: Select all

create or replace
FUNCTION F_TEST(test varchar2) RETURN test_table_of_tests AS
  v_ret test_table_of_tests;
BEGIN
  v_ret := test_table_of_tests();
  v_ret.extend;
  v_ret(v_ret.count) := test_type_test(1, test);
  return v_ret;
END F_TEST;

Here are my type test_table_of_tests

Code: Select all

create or replace
type test_table_of_tests as table of test_type_test

And my TYPE

Code: Select all

create or replace
TYPE TEST_TYPE_TEST  AS OBJECT
    ( id           NUMBER
    , test        VARCHAR2(10)
   ) ;

Now, if i create an Entitymodel and slect this function I get a custom tool error. Type TABLE is not qualified with a namespace or alias.

What can I do, to user the returning table in my model --> in my code?

Thanks
kind regards
Micha

[Shalex]

Entity Framework supports only primitive types: http://msdn.microsoft.com/en-us/library/ee382832.aspx. From the Entity Framework's point of view, an Oracle Table is not a primitive type.

[rednose84]

In this case, there is no way to solve my problem?

[Shalex]

Please use plain ADO.NET when working with Oracle Nested table type: http://www.devart.com/dotconnect/oracle ... Table.html.