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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
rednose84
Posts: 9
Joined: Wed 10 Nov 2010 08:07
Contact:

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

Post by rednose84 » Wed 15 Aug 2012 08:07

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
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 16 Aug 2012 16:34

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
Posts: 9
Joined: Wed 10 Nov 2010 08:07
Contact:

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

Post by rednose84 » Fri 17 Aug 2012 05:53

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

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 17 Aug 2012 08:30

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

Post Reply