Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exception on calling Oracle Stored procedure in C#.net using OMDA Assembly

User_OATN5Jan 3 2022

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:
image.pngOracleTesting.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:
image.pngNote: 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

Comments
Post Details
Added on Jan 3 2022
6 comments
1,902 views