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

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

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

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

Postby 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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

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

Postby rednose84 » Fri 17 Aug 2012 05:53

In this case, there is no way to solve my problem?
rednose84
 
Posts: 9
Joined: Wed 10 Nov 2010 08:07

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

Postby 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/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleTable.html.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle