Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is my code to use UTL_FILE Package to read and insert data. due 8 am est. what am i doing wrong? please advise. ?
This is my code to use UTL_FILE Package to read and insert data. due 8 am est. what am i doing wrong? please advise.
?
DECLARE
fh UTL_FILE_TYPE;
vBB_PRODUCT VARCHAR(100);
BEGIN
fh := UTL_FILE.FOPEN('ORA_FILE', 'tea.txt'. 'r';
IF UTL_FILE.IS_OPEN(fh) THEN
DBMS_OUTPUT.PUT_LINE ('File read open');
ELSE
DBMS_OUTPUT.PUT_LINE ('File read not open');
END IF;
UTL_FILE.GET_LINE (fh, BB_PRODUCT);
DBMS_OUTPUT.PUT_LINE ('Value read: ' | vBB_PRODUCT);
UTL_FILE.FCLOSE (fh);
END;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started