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.
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.
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.
Also read :