How to Create a Stored Procedure in Oracle


CREATE OR REPLACE PROCEDURE REGIONADD
(
  p_region_name regions.region_name%type
)
IS
BEGIN
  INSERT INTO regions(region_name) VALUES(p_region_name);
END REGIONADD;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document