Code: Select all
using (OracleConnection conn = new OracleConnection(@"User Id=my_user;Password=my_pw;Server=prod-db;Direct=True;Sid=CORP01;Port=1526;Persist Security Info=True")) {
conn.Direct = true;
await conn.OpenAsync();
var sql = @"
insert into my_table ( SCODE ,PCODE )
values (:col1, :col2 ) returning id into :output_id";
OracleParameter outputParam = new OracleParameter()
{
ParameterName = ":output_id",
Direction = ParameterDirection.ReturnValue
};
OracleParameter[] parameters = new OracleParameter[]
{
new OracleParameter(":col1", OracleDbType.VarChar, v.SCODE, ParameterDirection.Input),
new OracleParameter(":col2", OracleDbType.VarChar, v.PCODE, ParameterDirection.Input),
outputParam
};
var cmd = new OracleCommand(sql, conn);
cmd.Parameters.AddRange(parameters);
var vId = await cmd.ExecuteNonQueryAsync();
}
PLS-00103: Encountered the symbol "" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "" was ignored.
ORA-06550: line 2, column 65:
PLS-00103: Encountered the symbol "" when expecting one of the following:
( select values
The symbol "" was ignored.