I'm set up a test with EF Core 6.21.61 accessing a 11G db.
accessing all data of tables is no problem, but running queries on primary keys throws ORA-03111: Break received on communication channel
when looking at the debug query I see that it shows that it uses dbms_sql.return_result which afaik is introduced in oracle 12.
Any help would be appreciated!
DECLARE
l_sql varchar2(32767);
l_cur pls_integer;
l_execute pls_integer;
BEGIN
l_cur := dbms_sql.open_cursor;
l_sql := 'SELECT "d"."MUOB_ID", "d"."SHORTTITLE", "d"."TITLE"
FROM "DADS"."MUSICOBJECTS" "d"
WHERE "d"."MUOB_ID" = :id_0';
dbms_sql.parse(l_cur, l_sql, dbms_sql.native);
dbms_sql.bind_variable(l_cur, ':id_0', 1);
l_execute:= dbms_sql.execute(l_cur);
dbms_sql.return_result(l_cur);
END;