Create Procedure in (PL/SQL) called Make_Account (v_first, v_last, v_email, v_errormsg) Add a new user to the...

Create Procedure in (PL/SQL)

called Make_Account (v_first, v_last, v_email, v_errormsg)

Add a new user to the Account table. If the new user cannot be added, return a error message.

Table Account (this is the table I need to add data using PROCEDURE)

Account_no (PK)

Email (VARCHAR2)

first (VARCHAR2)

last (VARCHAR2)

Solutions

Expert Solution

Table created usiing identity as your question specified to insert except account number as Make_Account (v_first, v_last, v_email, v_errormsg)

Note : Stored proecduere created. But your question says to insert v_errormsg in call (Make_Account (v_first, v_last, v_email, v_errormsg)) I can not understand the logic behind it passing v_errormsg . how we know the error before insert as user who inserts value . Anyway i did as you reqqueted but i display the oracle's SQLERRM when error occurs.

successful insert showing procedure code ouptut

Failed insert ouptut as i mssed one parameter to demonstrate how error handling works

I used value_error for example . You can use others in exception

venereology answered 6 months ago

Next > < Previous

Related Solutions

PL/SQL Write a PL/SQL block, using a While Loop, to calculate and print the sum of...

PL/SQL Write a PL/SQL block, using a While Loop, to calculate and print the sum of the odd integers from 10 to 120 inclusive. (Hint: 11 + 13 + 15 + . . . + 97 + 99)

PL/SQL Write a PL/SQL block, using a Case Statement that prints a student’s letter grade...

PL/SQL Write a PL/SQL block, using a Case Statement that prints a student’s letter grade based on the value stored in a variable called grade. Use the ACC grading system described in the course syllabus to create the block and set the initial value of grade as 95. Use only one print statement and no logical operators in your code. Assume a grade can exceed 100, but it can’t be negative. Grade Scale: Grade Scale:...

Assignment 2- 9 USING A FOR LOOP Create a PL/SQL block using a FOR loop to...

Assignment 2- 9 USING A FOR LOOP Create a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is to be paid monthly in equal increments. The values variable for the block is starting payment due date, monthly payment amount, and a number of total monthly payments for the pledge. The list that’s generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining...

Using SQL create a new database called school_app. Create a student table with fields id (auto...

Using SQL create a new database called school_app. Create a student table with fields id (auto increment), first_name, last_name. Create a course table with fields id (auto increment), course code (such as ITC or MTH), and course number (such as 100 or 295). Note that the relationship between student and course is many-to-many (n:m). Create a join table called student_course that implements the n:m relationship with fields id (auto increment), student_id, course_id, and grade (which has values 0, 1, 2,...

ORACLE TASK 2-2 USING A FOR LOOP Create a PL/SQL block using a FOR loop to...

ORACLE TASK 2-2 USING A FOR LOOP Create a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is to be paid monthly in equal increments. Values variable for the block are starting payment due date, monthly payment amount and number of total monthly payments for the pledge. The list that’s generated should display a line for each monthly payment showing payment number, date due, payment amount, and donation balance (remaining amount of...

Create a PL/SQL anonymous block that uses a nested loop (inner loop 1 to 15; outer...

Create a PL/SQL anonymous block that uses a nested loop (inner loop 1 to 15; outer loop 1 to 5) to perform computations using the SQL functions, ABS, EXP, SQRT, ROUND, MIN, MAX, LOG, MOD, REMAINDER and POWER The outer loop will use the functions, ABS, EXP, SQRT, ROUND to display the following messages (must be “ The absolute value of <outer loop index> is <value>” “ The value of e to the <outer loop index> power is <value>” “...

Developer User Account Create a user account using T-SQL for developers named DEVELOPER with the password...

Developer User Account Create a user account using T-SQL for developers named DEVELOPER with the password TESTACCOUNT that grants the user the ability to: Select and modify any table. Connect to and have access to all resources. In SSMS

Create a stored procedure that can be used to add a student to the school and...

Create a stored procedure that can be used to add a student to the school and a section of a course. 1. If the student already exists, then just add him to the section (do not update information like address). 2. The procedure will require the following arguments (see table definition for types): A. Salutation B. First Name C. Last Name D. Street Address (including City) E. ZIP Code F. Phone Number G. Employer Name (if any) H. Course Number...

Write a bash script that... create new user ./finalProject user if a new user is to...

Write a bash script that... create new user ./finalProject user if a new user is to be created ask for the new users information and use it when creating the new user add a new printer ./finalProject printer ask anything you need in order to create the new printer (I.e. name) permissions ./finalProject permissions ask what document and permissions the user wants restarting the computer ./finalProject restart

Create a java program that will do the following: Create a method called getInt.Allow the user...

Create a java program that will do the following: Create a method called getInt.Allow the user to enter up to 20 student names,and for each student 3 quiz scores (in the range 0-100). Once input is done, display each student’s name, their three quiz scores, and their quiz score average, one student per line. The output table does not need to line up perfectly in columns.Use dialog boxes for all input and output.Use the method to input the three scores.Parameter...

Subjects