DateTime dt = DateTime.Now; OracleCommand objCommand = new OracleCommand(); connection.Open(); objCommand.Connection = connection; objCommand.CommandText = "PKG_DBMON_MASTER.dbmon_dbinfo(INS)"; objCommand.CommandType = CommandType.StoredProcedure; // objCommand.Parameters.Add("p_made", OracleType.VarChar).Value = "INS"; // objCommand.Parameters.Add("p_db_id", OracleType.VarChar).Value = 001; objCommand.Parameters.Add("name",OracleType.VarChar).Value = txtName.Text; objCommand.Parameters.Add("owner_name", OracleType.VarChar).Value = txtOwnerName.Text; objCommand.Parameters.Add("owner_email", OracleType.VarChar).Value = txtOwnerMail.Text; objCommand.Parameters.Add("project", OracleType.VarChar).Value = txtProject.Text; objCommand.Parameters.Add("created_date", OracleType.DateTime).Value = dtpCreatedDate.Text; // objCommand.Parameters.Add("p_droped_date", OracleType.DateTime).Value =null; objCommand.Parameters.Add("sys_passwd", OracleType.VarChar).Value = "password"; objCommand.Parameters.Add("system_passwd", OracleType.VarChar).Value = "password"; objCommand.Parameters.Add("status",OracleType.VarChar).Value = txtStatus.Text; objCommand.Parameters.Add("srv_id", OracleType.Number).Value = decimal.Parse(txtServerID.Text); objCommand.Parameters.Add("dbms_id",OracleType.Number).Value =decimal.Parse(txtDBMSID.Text); objCommand.Parameters.Add("db_type", OracleType.VarChar).Value = txtStatus.Text; objCommand.ExecuteNonQuery();
ORA-06550: line 1, column 7: PLS-00801: internal error [22503] ORA-06550: line 1, column 7: PL/SQL: Statement ignored
objCommand.BindByName
username.PKG_DBMON_MASTER.dbmon_dbinfo(INS)
PKG_DBMON_MASTER.dbmon_dbinfo()
using
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)