A Stored Procedure of selecting the contents of a ref cursor as part of a SQL Select statement


CREATE OR REPLACE PROCEDURE TESTPROCEDURE (v_refcur IN OUT SYS_REFCURSOR)
IS
BEGIN
  OPEN v_refcur FOR SELECT * FROM regions;
END TESTPROCEDURE;

Comments

Popular posts from this blog

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

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