Page 119 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

This stored procedure, named GetGreeting, takes an input parameter input name and returns an output parameter
greeting result.
3 Call the Stored Procedure:
Now, you can call the stored procedure and capture the output. You’ll use the CALL statement to execute the
stored procedure.
SET @name = ‘John’;
CALL GetGreeting(@name, @greeting);
SELECT @greeting AS GreetingOutput;
In this example, @name is the input parameter, and @greeting is the output parameter. Replace ‘John’ with the
desired input value.
4 View the Output:
After executing the above commands, you should see the output of the stored procedure.

The output shows the result of the stored procedure, which is the greeting message based on the provided input.
5 Drop the Stored Procedure:
If you want to remove the stored procedure, you can use the following command:
DROP PROCEDURE IF EXISTS GetGreeting;
This step is optional and can be done if you no longer need the stored procedure.

104
CITS : IT & ITES - Computer Software Application - Exercise 31