Hi Developers,
My Function return following error
"System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7:" & vbLf & "PLS-00221: 'TESTING2' is not a procedure or is undefined".
When I change it to do "Select testing() from dual" and change CommandType to Text, it works. What am I missing?
Dim oracleConn As OracleConnection = CreateConnection(<connection info here>)
Dim oracleCmd As New OracleCommand()
oracleCmd.Connection = oracleConn
'oracleCmd.CommandText = "SELECT TESTING2() FROM DUAL" 'this works
oracleCmd.CommandText = "TESTING2" 'this does not work
oracleCmd.CommandType = CommandType.StoredProcedure
'oracleCmd.ExecuteReader() 'also tried this
Dim tmpVar As String = oracleCmd.ExecuteScalar()
create or replace FUNCTION testing2
RETURN VARCHAR2
AS
begin
return 'hello';
end;
Any help would be amazing thank you!
AVADHESH PATEL
12-Jun-2013