Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!