HELP WITH DEBUG THE FOLLOWING PROCEDURE STATEMENT: CREATE OR REPLACE PROCEDURE F

Question

HELP WITH DEBUG THE FOLLOWING PROCEDURE STATEMENT:

CREATE OR REPLACE PROCEDURE F_Procedure (v_rep_num IN CHAR, v_L_Name IN VARCHAR2, v_F_Name IN VARCHAR2, v_Street IN VARCHAR2,
v_City IN VARCHAR2, v_State IN CHAR, V_Zip IN CHAR, v_Commission IN NUMBER, v_rate IN NUMBER,
v_Error_Number OUT NUMBER, v_Error_Msg OUT VARCHAR2) AS
v_State_Count NUMBER;

Duplicate_Record EXCEPTION;

PRAGMA EXCEPTION_INIT(Duplicate_Record,-0001);

Begin
v_State_Count = VALIDATE_State(v_state);
IF v_State_Count = 1 THEN
INSERT INTO rep VALUES (v_rep_Num, v_Last_Name, v_First_name, v_Street, v_City, v_State, v_Zip, null, v_rate);

ELSE
v_Error_Number = -1;
v_Error_Msg = 'Not A Valid State';
END IF;
EXCEPTION
WHEN Duplicate_Record THEN
v_Error_Number := -5;
v_Error_Msg := 'Rep Already Exists';
Dbms_Output.Put_Line('Error --- Duplicate Record Exists');
WHEN OTHERS THEN
Dbms_Output.Put_Line('SQLCODE = 'SQLCODE);
Dbms_Output.Put_Line('SQLERRM = '||SQLERRM);

END F_Procedure;

DECLARE
errcode NUMBER;
errorMesg VARCHAR2(50);
BEGIN
insert_rep ('11','Nath','Madge','2773 Wormwood Street','Cheshire','NJ',72529,10812.7,.16,errcode,ErrorMesg);
Dbms_Output.Put_Line(errcode ||' == ' ||ErrorMesg);
END;

Explanation / Answer

The program consist no bugs.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.