Hello everyone! I have a produre that I can not get to compile. I keep getting the message "Warning: Procedure created with compilation errors." I'm not getting any help when I type "show errors" Below is my code and input.txt file is attached.
-----------------------------------------------------------------
CREATE OR REPLACE PROCEDURE insert_rec
(p_FileDir in Varchar2, p_FileName Varchar2)
as
--Declare
V_count Number;
V_cust_num Number(6);
V_cust_name Varchar2(25);
V_cust_addr Varchar2(25);
V_city Varchar2(20);
V_cust_zip Number(5);
V_Cred_Lim Number(1);
V_Bal_Due Number(7);
V_Cust_Phone Char(12);
V_Rec_Type Number(1);
V_Valid Number(1);
V_Line Varchar2(20);
V_FileHandle UTL_FILE.FILE_TYPE;
BEGIN
V_FileHandle := UTL_File.Fopen (P_FileDir, P_FileName,'r');
LOOP
BEGIN
UTL_File.Get_Line(V_FileHandle, V_Line);
Select count(*) into V_Valid
From cust_entry
Where cust_number = V_cust_num;
IF V_Valid := 1 THEN
INSERT INTO CUST_ENTRY
VALUES(V_cust_num, V_cust_name, V_cust_addr, V_city, V_cust_zip, V_Cred_Lim, V_Bal_Due, V_Cust_Phone, V_Rec_Type);
END IF;