I know that in Ukraine now is good weather, but...
I have a stored function:
Code: Select all
create or replace function TestStoredFunction() return sys_refcursor
as
result sys_refcursor;
begin
open result for select 0 as Result, Sys_Guid() from dual;
return result;
end;
Code: Select all
var cmd = conn.CreateCommand()
{
CommandType = CommandType.StoredProcedure,
CommandText = "TestStoredFunction",
};
var reader = cmd.ExecuteReader();
Code: Select all
PLS-00221: 'TESTSTOREDFUNCTION' is not a procedure or is undefined