I use oracle 12c and want call Stored Function that return scalar result (varchar2 oracle data type).
according "Stored Function with Scalar Result" in entity developer document I can implement method that mapped to special oracle function.
but when run my project in visual studio 2017 I got this error:
Code: Select all
{"ORA-06550: line 1, column 8:
PLS-00221: 'FNC_GET_NO' is not a procedure or is undefined
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored"}
System.Exception {Oracle.ManagedDataAccess.Client.OracleException}
Code: Select all
result = (string)command.ExecuteScalar();