Home » Interview » Technology

How can we read and write operating system files from PL/SQL program?

Correct Answer: The UTL_FILE database package can be used to read and write operating system files You need to have read /write access rights in that directory before the package can be used Example to write file: Fhandler is a variable of type UTL_FILEFILE_TYPE UTL_FILEPUTF(fHandler, 'Im writing to a file\n'); Example to read file: UTL_FILEGET_LINE(fHandler, buf);

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion