hi,
Please send me an example of writting a log file in a stored procedure with the UTL__FILE package
http://www.experts-exchange.com/Database/Oracle/Q_10049896.html
Zones:
OracleDate Answered: 04/27/1998 Grade: A Views: 9
Hello,
I have a user that is executing some pl/sql. He opoens a file with UTL_FILE.FOPEN and then writes some things and closes the file. BUT the file is owned by unix user "oracle" with a group...
http://www.experts-exchange.com/Database/Oracle/Q_10233931.html
Zones:
OracleDate Answered: 11/22/1999 Grade: A Views: 8
Hi,
This is my pl/sql block for reading a file,the same works for writing and appending by chnaging the Mode.
DECLARE
fileHandler UTL_FILE.FILE_TYPE;
buff varchar(1000); ...
http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q_20423413.html
Hi
I am trying to generate a UTL file on a mapped drive on the server but it gives me the oracle error :- ORA-20051 Invalid Operation. My o/s is Windows 2000 Advanced Server and the oracle vers...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20616403.html
I am not sure whether I have put this question in the right place.
I am writing a store procedure.
CREATE OR REPLACE PROCEDURE FILEREAD
(mainStrFilePath CHAR, mainStrFileName CHAR) IS
bw UTL_...
http://www.experts-exchange.com/Database/Oracle/Q_20621587.html
Zones:
OracleDate Answered: 08/08/2003 Grade: A Views: 0
1. Is it possible to open a file from Oracle (e.g a notepad file or a word document)?
I need the file to be opened in a seperate window when the command is given and on closing the file, control s...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20649360.html
Zones:
DatabasesDate Answered: 06/18/2003 Grade: A Views: 0
Using UTL_FILE, how can I send a carriage-return/line-feed set (0x0d 0x0a) to a file?
Everything I try sends the 4 characters '13' and '10'.
http://www.experts-exchange.com/Database/Oracle/Q_20945748.html
Zones:
OracleDate Answered: 04/07/2004 Grade: A Views: 40
I am trying to generate a file using UTL_FILE in my oracle stored procedures...
however I am getting an exception "invalid_path"...
this is my code below... May I ask if there is something ...
http://www.experts-exchange.com/Database/Oracle/Q_21024502.html
Zones:
OracleDate Answered: 06/18/2004 Grade: A Views: 143
I've been receiving this error, but looking up in documentation it says that this is an O/S error and that's it.
I'm just PUTting and PUT_LINE-ing data to a file. I get through about 22 iterati...
http://www.experts-exchange.com/Database/Oracle/Q_21121952.html
Zones:
OracleDate Answered: 09/07/2004 Grade: A Views: 10
Hi:
I am trying to use the UTL_FILE package to write a string to a text file.
In the following test code, is there a way to break the barrier of 32760 bytes
for the PUT method of the UTL_FIL...
http://www.experts-exchange.com/Database/Oracle/Q_21607316.html
Zones:
OracleDate Answered: 01/20/2006 Grade: B Views: 0
