How do you call a package in Oracle SQL Developer?

How do you call a package in SQL Developer?

After couple of tries, I found an easy way to execute the stored procedure from sql developer itself.1Under packages, select your desired package and right click on the package name (not on the stored procedure name).2You will find option to run. Select that and supply the required arguments.

How do I run a package in SQL?

Right-click the package name and select Execute. Configure the package execution by using the settings on the Parameters, Connection Managers, and Advanced tabs in the Execute Package dialog box. Click OK to run the package. Use stored procedures to run the package.

How do I call a procedure in Oracle SQL Developer?

You can also execute a procedure from the Oracle SQL Developer using the following steps:1 Right-click the procedure name and choose Run… menu item.2 Enter a value for the in_customer_id parameter and click OK button.3 The following shows the result.

How do I run a PL SQL package in SQL Developer?

Assuming you already have a connection configured in SQL Developer:1from the View menu, select DBMS Output.2in the DBMS Output window, click the green plus icon, and select your connection.3right-click the connection and choose SQL worksheet.4paste your query into the worksheet.5run the query.