Read directories in pl/sql

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Thu, 03 Nov 2005 8:57 am

Good morning, I need to do a procedure that reads a directory and fetch the last recorded day. txt file file name has the format XXXYYYYMMDDHHMISS. Can anyone give me any tips?

Thank You, Marcia
Márcia de Paiva Salles
Location: DF

Poston Thu, 03 Nov 2005 10:03 am

Well ... There must be a better way than this that I'm going to suggest: this link has a routine that executes SHELL commands/of the server. (it's a procedure in java): viewtopic.php?p=1030 with her, you can give a
Code: Select all
DIR xxx* /O-D /a-d /b >ARQ.TXT
then you just read that ARQ.TXT with UTL_FILE and grab the first line. (this will be the last generated)

As I said: there must be a better way.

[] ´ s
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

  • See also
    Last Post

    Return to PL/SQL

    Who is online

    Users browsing this forum: No registered users and 15 guests