List of Stored Procedures
Posted: Mon 20 Sep 2010 08:32
Hi !
Is there a way, to get a List of my Stored Procedures?
Is there a way, to get a List of my Stored Procedures?
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
using (OracleConnection conn = new OracleConnection())
{
conn.ConnectionString = "server=ora1110;uid=scott;pwd=tiger;";
conn.Open();
DataTable table = conn.GetSchema("Procedures");
DataTable table2 = conn.GetSchema("Procedures", new string[] { "schema_name" });
DataTable table3 = conn.GetSchema("Procedures", new string[] { "schema_name", "package_name" });
DataTable table4 = conn.GetSchema("Procedures", new string[] { "schema_name", "package_name", "procedure_name"});
}