Re: Reading Text files in Stored Procedure
Date: 23 Feb 1995 04:56:50 GMT
Message-ID: <3ih4ii$dcs_at_socrate>
In article <3idsku$m7n_at_uuneo.neosoft.com>, jward_at_starbase.neosoft.com (James R. Ward) says:
>
>I've been looking throught the 237.4 reams of manuals, but still can't
>find the answer to a question:
>
>Can I do file i/o from a stored procedure? I want to read a fixed width
>text file into a table in a stored procedure. (I don't want to use the
>loading utility, if I can avoid it, for a number of reasons.)
To my knowledge no. What we did, is to use dbms_pipes function to communicate with an external program written in PRO*something that wait for a request on a pipe and then execute the command and return the result back.
Look at dbms_pipe in the application developer's guide.
Hope it helps Received on Thu Feb 23 1995 - 05:56:50 CET