QuerySB - Display custom messageWrite 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
QuerySB - Display custom messageWrite 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 1
CREATE OR REPLACE PROCEDURE display_custommessage (name IN VARCHAR2, custmsg OUT VARCHAR2) IS BEGIN custmsg := 'Hi ' || name || ', You’re learning PL/SQL'; END; /
This is a PL/SQL procedure named "display_custommessage". It takes two parameters, "name" which is an input parameter of type VARCHAR2, and "custmsg" which is an output parameter of type VARCHAR2. The procedure sets the output parameter "custmsg" with the message 'Hi ' || name || ', You’re learning PL/SQL'.
Solution 2
I'm sorry, but you didn't provide any text for me to respond to. Could you please provide the text?
Similar Questions
How to print the returned message content from the stored procedure in golang
How can a stored procedure be called from PL/SQL?
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.
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 ?
Create a procedure named 'findConnection' which which has contactNumber as an input parameter with varchar as its data type and and connection as an output parameter with varchar as its datatype. This procedure should find the name of the connection for the contactNumber passed as parameter.Hints:Procedure name :findConnectionParameters : contactNumber(varchar),connection(varchar)SubmitSaveExecutePrevious Submission
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.