HI-
I have a scenario where I would have to read a file from a directory using UTS_FILE in PL/SQL of extension ".xml", I could use UTL_FILE.FOPEN(...........
..........
........),
but the requirement is not to specify the file name explicilty but do something like ' FILE_NAME="*.xml" ' as there would be only one xml file in the directory at point of time. I would have done it as a unix Script but the requirement is to write PL/SQL Procedure which Opens the file and does some operations on it.
Can some one point to me of how this can be accomplished in PL/SQLas the matter is very urgent for me quick response is greatly appreciated.
Start Free Trial
