Execute Stored Procedure

How to login with Putty & Execute Stored Procedure

Have you ever execute stored procedure other than Toad or SQL Developer Software . If not then i will tell you how to execute stored procedure using Putty Software.

If you don’t know  about Toad& SQL Developer . They are database management tool set that database developers, database administrators, and data analysts use to manage both relational and non-relational databases using SQL.

How to login with Putty & Execute Stored Procedure

What is Putty ?

If you dont know about Putty , I will tell you Putty is a free and open-source terminal emulator, serial console and network file transfer application. It supports several network protocols, including SCP, SSH, Telnet, rlogin, and raw socket connection. It can also connect to a serial port.

Download PuTTY

You can download PuTTY here. Its very small tiny  software it will not take much space in your system. It is very fast & Easy to work on this software .

First we will write stored procedure for giving demo to execute stored procedure .

 CREATE OR REPLACE PROCEDURE GET_EMPCODE( PDIS VARCHAR2) AS P_EMPCODE VARCHAR2; BEGIN SELECT EMPLOYEE_CODE INTO P_EMPCODE FROM  EMP_MAST WHERE DIST_CODE=PDIS ORDER BY 1; END; / 

Now we have to execute this stored procedure using putty software.

We will go step by step for executing our stored procedure.

Steps are as follows :

1. Open putty software .open host name with IP Address.

2. logging into oracle server with user ID password.

3. Login into schema by sql plus command.

4. Then execute your procedure.

These are the simple steps used for executing stored procedure using putty.

I have made this step by step video for Executing stored procedure in putty.

Also read :

Learn Oracle PL/SQL : Create Procedure & Use
Learn Oracle PL/SQL : Create & Use View
Learn Oracle PL/SQL : Create & Use Tables
Learn Oracle PL/SQL : Variables
Top 10 ORACLE PL/SQL Interview Questions

  •  
    26
    Shares
  • 26
  •  
  •  
  •  
  •  
  •  

About the Author

Prashant Goswami

I am the blog writer who will teach how to love programming. My experience in programming is about 6 years. And i am the lover of programming , so i will make you people.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: