Oracle. DataAccess. Client
System. Data
String oraSql="insert into ora_vssample values (: a: b: c: d)";
OraCommand. The Parameters. The Add (" a ", OracleDbType Varchar2, "100100", ParameterDirection. Input);
OraCommand. The Parameters. The Add (" b ", OracleDbType Varchar2, "Pen", ParameterDirection. Input);
OraCommand. The Parameters. The Add (" c ", OracleDbType Varchar2, "ORA1100 ParameterDirection. Input);
OraCommand. The Parameters. The Add (" d ", OracleDbType Varchar2, "2", ParameterDirection. Input);
To successfully execute this way the insert into statement is
But it doesn't work the same way to delete is why?
String oraSql="delete from ora_vssample where ora_id=: paramId";
OraCommand. The Parameters. The Add (" paramId, "OracleDbType Varchar2," ORA1100 ParameterDirection. Input);
Pray god help solve
CodePudding user response:
The building Lord say what specific error, the estimate is made implicit data conversion when make a mistake,By the way, table structure, including the field type,
CodePudding user response:
Oracle should delete statements don't pick up after the from?