JAVA:
String strSql = "{call insert into DATA_DICT_TYPE (DICT_NAME,DICT_KEY) values(?,?) returning id INTO ? }";
CallableStatement ps = conn.prepareCall(strSql);
ps.setString(1, "??");
ps.setString(2, "??");
ps.registerOutParameter(3, Types.INTEGER);
result = ps.executeUpdate();
if (result > 0) {
BigDecimal bd = ps.getBigDecimal(3);
}
C#:
using (DbConnection conn = new SqlConnection("connstr"))
{
conn.Open();
string strSql = "insert into DATA_DICT_TYPE (DICT_NAME,DICT_KEY) values(:DICT_NAME,:DICT_KEY) returning id INTO :id";
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = strSql;
DbParameter param1 = new SqlParameter();
param1.ParameterName = "DICT_NAM