Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: From PL/SQL: Get file date and size
A copy of this was sent to "Finn Ellebaek Nielsen" <fen_at_changegroup.dk>
(if that email address didn't require changing)
On Wed, 16 Jun 1999 11:42:30 +0100, you wrote:
>How can I get timestamp and size for a given file from PL/SQL? I realize I
>can use External Procedures with 8.0 + 8.1, Java with 8.1, PLEX with 7.x but
>I want to be able to do this from standard PL/SQL with 7.3 and onwards. That
>way I don't have to port an external procedure to a bunch of different
>platforms.
>
that is the only way to do this however. There exist no internal routines to get this information.
>UTL_FILE only allows you to read/write files, not to get any info on them,
>which would be nice to have here. It would also be nice to be able to see if
>a file actually exists without having to try to create one...
>
>Out of curiosity: How is the package body for UTL_FILE actually implemented?
>Using function pointers to call directly into the kernel or how does it
>work?
>
Yes, its implemented in C as kernel callouts. Similar to extprocs
>Thanks.
>
>Finn
>
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/
Current article is "Fine Grained Access Control", added June 8'th
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA--