---
title: "How to Run Stored Procedure in SQL Developer"
description: "Here are steps of how to create a procedure in SQL developer and how to call it."
url: https://srinimf.com/2021/11/27/how-to-run-stored-procedure-in-sql-developer/
date: 2021-11-27
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2021/11/procedure-in-sql-developer-new.png?fit=1200%2C675&ssl=1
categories: ["SQL", "SQL Stored Procedures"]
tags: ["Stored procedures tips"]
type: post
lang: en
---

# How to Run Stored Procedure in SQL Developer

Here are the steps [to run](https://srinimf.com/2016/03/10/how-to-run-a-query-in-qmf-automatically/) the [stored procedure](https://srinimf.com/2014/01/05/informatica-stored-procedure/) in Oracle. They reside in the database. The ***return*** keyword you must not use in stored procedures. Why because only functions support the return keyword.

The stored procedure begins with **create or replace procedure .** You’ll learn in three steps create/verify/run the procedure.

## **Create Stored procedure**

```
create or replace procedure mytestproc (in_dt DATE)
is
    v_out_tx VARCHAR2(10);
    v_flag_b BOOLEAN;
begin
    if to_char(in_dt,'d')=1 then
        v_out_tx:='Y';
        dbms_output.put_line(v_out_tx);
    else
        v_out_tx:='N';
        dbms_output.put_line(v_out_tx);
    end if;
end;
```

Input for the procedure, you can supply in the parenthesis ( the variables and their data types). The other variables you can declare in the declaration section ( after the ‘is’).

## **Verify stored procedure is created**

Here is a sample SQL query to verify if the procedure is created.

```
select * 
  from user_procedures 
 where object_type='PROCEDURE';
```

Advertisements

## **Call stored procedure**

Now, this is the time to call. The CALL keyword is the first one you need to give. Then supply the date. The to_char function checks the day of the week supplied is numeric (since the ‘d’ checks for day of the week).

If the Date is numeric, you can see** Y **else **N**.

#### **SQL query to call procedure**

```
CALL mytestproc('27-NOV-21');
```

The output

```
N
```

Related posts

- [Internal Process How Stored Procedure Executes](https://srinimf.com/2016/06/19/3-steps-how-stored-procedure-works-in-db2/)DateJune 19, 2016
- [How to Create a Generic Stored Procedure for KPI Calculation (SQL + AWS Lambda)](https://srinimf.com/2026/04/04/how-to-create-a-generic-stored-procedure-for-kpi-calculation-sql-aws-lambda/)DateApril 4, 2026
- [How to Register Stored Procedures in a DB2 Catalog Table](https://srinimf.com/2023/04/03/how-to-register-stored-procedures-in-a-db2-catalog-table/)DateApril 3, 2023

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2021%2F11%2F27%2Fhow-to-run-stored-procedure-in-sql-developer%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2021%2F11%2Fprocedure-in-sql-developer-new.png%3Ffit%3D1200%252C675%26ssl%3D1&description=How%20to%20Run%20Stored%20Procedure%20in%20SQL%20Developer)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2021/11/27/how-to-run-stored-procedure-in-sql-developer/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2021/11/27/how-to-run-stored-procedure-in-sql-developer/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2021/11/27/how-to-run-stored-procedure-in-sql-developer/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2021/11/27/how-to-run-stored-procedure-in-sql-developer/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Run%20Stored%20Procedure%20in%20SQL%20Developer&body=https%3A%2F%2Fsrinimf.com%2F2021%2F11%2F27%2Fhow-to-run-stored-procedure-in-sql-developer%2F&share=email)
-

### Like this:

Like Loading…