Am trying to connect and fetch the data from the Oracle Stored Procedure in C# .Net application. But throws error on calling Stored procedure in C# application. I can execute the same procedure without any problem using SQLPLUS Developer tool.
Sample code:
OracleTesting.zip (4.15 KB)It throws the following error on statement command.ExecuteReader(), I have no idea where to look for the error.
"ORA-00900: invalid SQL statement"
Stack trace:
Note: I couldn't know about the type of Query text whether it is SQL table or Procedure. I need to execute the query directly, using the above attached codes.
Your help will be appreciated.
Thanks, Ravi