Message=ERROR [HY000] [Oracle][ODBC][Ora]ORA-00936: missing

Question

I am able to retrieve the information I want from a table, based on certain input in LINQPad 4, as seen below:

I want to retrieve the same information, based on the same input in Visual Studio Professional 2010, based on the attached code, but with error as atttached:
It is able to go through the code, and show the message box with the word "Connected".
Appreciate any help.

Attachment: code.zip

Muralidharan Deenathayalan · Answer

Did a screenshare with him and finally found the reason. We need to use ? for the command parameters. cmd.CommandText = SELECT VHITNO FROM MWOHED WHERE VHMFNO =?  ; cmd.Parameters. AddWithValue ( @VHMFNO  MO_No); Hope this helps TAN and someone !

TAN WhoAMI · Answer

Muralidharan  THANK YOU VERY MUCH FOR YOUR HELP.

TAN WhoAMI · Answer

https://join.me/811-349-855

Muralidharan Deenathayalan · Answer

Is that possible for you to do screenshare by using https://join.me or teamviewer or any other app?

TAN WhoAMI · Answer

yes I add the schema name now pfods.MWOHED. for Oracle's NUMBER is the C# Datatype Int32? for Oracle's NUMBER(156) is the C# Datatype Int64? I keep on getting the error message Error contacting database. I attached the whole project with the printscreen for the LINQPAD.

Muralidharan Deenathayalan · Answer

In your query there is no schema name is present but in your LINQPad query it is present. Schema name added. cmd.CommandText = SELECT VHITNO FROM pfods.MWOHED WHERE VHMFNO =' + MO_No + ' ;

TAN WhoAMI · Answer

pls see attached file. Message=ERROR [42S02] [Oracle][ODBC][Ora]ORA-00942: table or view does not exist

Muralidharan Deenathayalan · Answer

Can you please the call stack? that tells you complete call hierarchy. I'm attached the parameter the query + cmd.ExecuteReader() is changed. We will try without commandbehaviour option. //Just hardcode the complete query cmd.CommandText = SELECT VHITNO FROM MWOHED WHERE VHMFNO =' + MO_No + ' ; //Later include the single quotes in the query. //cmd.Parameters.AddWithValue(@VHMFNO MO_No); //cmd.CommandText = SELECT VHITNO FROM MWOHED WHERE VHMFNO =' + @VHMFNO + '; con. Open (); MessageBox. Show ( Connected ); try { OdbcDataReader reader = cmd. ExecuteReader (); if (reader. Read ()) { ProductionInfo productioninfo = new ProductionInfo ((String)reader[ VHITNO ]); return (productioninfo); } else { return null ; } } finally { con. Close (); }

TAN WhoAMI · Answer

the error comes from code which contain the try.. finally... it does not go into the try portion of the code but goes into finally portion of the code.

TAN WhoAMI · Answer

I try your suggestion as attached but got the same error:

Muralidharan Deenathayalan · Answer

Hi Try this way. //Just hardcode the complete query cmd.CommandText = SELECT VHITNO FROM MWOHED WHERE VHMFNO =' +MO_No + ' ; //Later include the single quotes in the query. cmd.CommandText = SELECT VHITNO FROM MWOHED WHERE VHMFNO =' +@VHMFNO + ' ; cmd.Parameters. AddWithValue ( @VHMFNO  MO_No);