Write a PL/SQL simple procedure named display_custommessage with 2 parameters. The first input parameter is name of type varchar. The second output parameter is custmsg of type varchar. This procedure will set the output parameter message with ‘Hi <name>, You’re learning PL/SQL’.Use the below skeleton:Procedure name: display_custommessageInput parameter: name of type varcharOutput parameter: custmsg of type varcharNote:Do not change the procedure nameDo not change the argument count and orderDo not change the output text.Instructions:1. Create the procedure successfully2. Once the procedure is created, check the functionality of the procedure using different anonymous block call.3. DO NOT submit the anonymous block. Submit only the CREATE PROCEDURE query.Sample Input and Output:If the input parameter is 'Alice', then the sample output will be below:
Question
Write a PL/SQL simple procedure named display_custommessage with 2 parameters. The first input parameter is name of type varchar. The second output parameter is custmsg of type varchar. This procedure will set the output parameter message with ‘Hi <name>, You’re learning PL/SQL’.Use the below skeleton:Procedure name: display_custommessageInput parameter: name of type varcharOutput parameter: custmsg of type varcharNote:Do not change the procedure nameDo not change the argument count and orderDo not change the output text.Instructions:1. Create the procedure successfully2. Once the procedure is created, check the functionality of the procedure using different anonymous block call.3. DO NOT submit the anonymous block. Submit only the CREATE PROCEDURE query.Sample Input and Output:If the input parameter is 'Alice', then the sample output will be below:
Solution
Here is the PL/SQL procedure as per your requirements:
CREATE OR REPLACE PROCEDURE display_custommessage (name IN VARCHAR2, custmsg OUT VARCHAR2) IS
BEGIN
custmsg := 'Hi ' || name || ', You’re learning PL/SQL';
END;
/
This procedure takes two parameters, name as input and custmsg as output. It concatenates the input name with the string 'Hi ' and ', You’re learning PL/SQL' to form the output message.
Please note that you need to call this procedure from an anonymous block or another PL/SQL block to test its functionality. The anonymous block is not included as per your instructions.
Similar Questions
Write a PL/SQL simple procedure named display_dates with 2 input parameter. The first input parameter is d1 of type date. The second input parameter is d2 of type date. This procedure will display the dates between d1 and d2(exclusive), each in a newline.Use the below skeleton:Procedure name: display_datesInput parameter: d1 of type date, d2 of type dateNote:Do not change the procedure nameDo not change the argument count and orderDo not change the output text.Instructions:1. Create the procedure successfully2. Once the procedure is created, check the functionality of the procedure using different anonymous block call.3. DO NOT submit the anonymous block. Submit only the CREATE PROCEDURE query.
How to print the returned message content from the stored procedure in golang
How can a stored procedure be called from PL/SQL?
give short definition for procedures in pl sql
Create procedure dept_count proc(in dept name varchar(20),out d count integer)beginselect count(*) into d countfrom instructorwhere instructor.dept name= dept count proc.dept nameendWhich of the following is used to call the procedure given above ?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.