Skip to content

Instantly share code, notes, and snippets.

@TwitchBronBron

TwitchBronBron/execute_stored_procedure.sql

Created December 17, 2019 16:01
Show Gist options
  • Save TwitchBronBron/974e8c87bda72266677ac3dc63410e76 to your computer and use it in GitHub Desktop.
Save TwitchBronBron/974e8c87bda72266677ac3dc63410e76 to your computer and use it in GitHub Desktop.
Download ZIP
How to execute a stored procedure in sqldeveloper
Raw
execute_stored_procedure.sql
exec dbms_output.enable(10000);
SET SERVEROUTPUT ON;
var myCursor REFCURSOR;
begin
--Schema.Package.Procedure(Parameters);
SCHEMA_NAME.PACKAGE_NAME.PROCEDURE_NAME(10,'',:myCursor );
END;
/
print myCursor;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment