Devart Forums

Code: Select all

			OracleUtils.OracleClientCompatible = true;
			OracleConnection oc = new OracleConnection();
			oc.ConnectionString = "pooling = false";
			oc.Direct = true;
			oc.Unicode = true;
			oc.AutoCommit = false;
			oc.Server = "10.60.1.183";
			oc.Sid = "XE";
			oc.UserId = "user";
			oc.Password = "*****";
			oc.Open();

			OracleCommand o2 = oc.CreateCommand();
			o2.CommandText = "Test.T1";
			o2.CommandType = CommandType.StoredProcedure;
			o2.Prepare();

			var r = o2.ExecuteScalar();

Code: Select all

create or replace
PACKAGE Test IS
	procedure T1;
	procedure T2(a in number);
END Test;

create or replace
PACKAGE body Test IS
	procedure T1 is begin null; end;
	procedure T2(a in number) is begin null; end;
END Test;