DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Max length for UTL_FILE filename parameter

991726Feb 18 2013 — edited Feb 18 2013

Simple question: What is the maximum length of the filename parameter for UTL_FILE (the name of the file - NOT the max size of the line, or the total size of the file!)? Oracle's documentation doesn't address it, and the Google gods are mute.

The answer appears to be 30, but I can't verify. Does anyone know for sure, or can point me to documentation stating this?

Unfortunately, this limitation is forcing me to rewrite several hours of PL/SQL code to a Unix shell script (not my most favorite thing to do). But, after FTPing a file (using a PL/SQL package) to my server, and checking if it's one that I've processed already, etc., I can't open it and read it with UTL_FILE (File not found error). If I shorten the name - no problem. (Of course, there's no way to shorten/rename the file from within PL/SQL using UTL_FILE.FRENAME because the name is too long! I'm sure you can see the Catch-22.)

Just wondering if anyone knows for sure. Thanks.
-Dan-