Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+2. What tactics are associated with this plan?

Answered: 1 week ago

Question

I need help with part b? (a) \{b\})

Answered: 1 week ago

Question

2. How should this be dealt with by the organisation?

Answered: 1 week ago

Question

explain what is meant by the term fair dismissal

Answered: 1 week ago