Hello Everyone, Thanks much for your responses and I appreciate your time. Steve Schulte Posted November 12, 0 Comments. Business Analyst. Syed Laiquddin Posted November 12, 0 Comments. Thanks much for your reply. Yes, I have got the answers already. How to solve the problem? Register or Login. Welcome back! Sign in with Email. Reset Your Password We'll send an email with a link to reset your password.
Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign up with Email. Sign in with email Enter the email address associated with your account. You auth link is expired or incorrect, please try again. Sign up with email Get the latest news, expert insights and market research, tailored to your interests.
Thanks as always. Tom, Thanks a lot for your information and advice. I have more questions related to this configuration: 1. Could you please list the reasons and some benefits of it? December 03, - am UTC.
Eugene, January 15, - pm UTC. Can I use UNC paths? Do I need to map a drive to the other server to be able to utilize. Thanks, Eugene. January 16, - am UTC. It says in part: b. I work in a networked system. How to create a directory from SQL when we are working under networked systems. I think there lies the problem. How to alleviate this?? Will the directory be created in my local machine or in the Server? Please help.
February 09, - pm UTC. Hi Tom, I am using Oracle 9. Email server is NetWare. Why am I getting this error, since I have full control on the parent folder? Hi , Why we need to grant execute on sys. Please suggest. April 22, - pm UTC. I am very sorry as not very good in coding April 24, - am UTC. Your DBA must have revoked it. You need to ask them to grant it to you. Tom, DB Version: If yes, which one. Regards, Dawar. July 05, - pm UTC. Are you working with your DBA?
Dawar, July 05, - pm UTC. Tom, DBA is not available. Generally I take care of his reposibilities in his absence. How to reinstall utlfile objects? Do I need to run any script. I do have some utl objcets.
How should I know which one we are missing? I'm not going there, sorry -- you want your DBA to work with you. You shouldn't have DBA privs and you must if you are installing stuff , that is "pretty dangerous", sort of like giving me root, I know just enough to be thoroughly dangerous.
Please, wait for the dba to come back, let them do the install too. Tom, It has worked. FOPEN returns a file handle, which must be passed to all subsequent procedures that operate on that file.
This function opens a file in Unicode for input or output, with the maximum line size specified. You can have a maximum of 50 files open simultaneously. With this function, you can read or write a text file in Unicode instead of in the database charset. Maximum number of characters for each line, including the newline character, for this file.
An exception is returned on failure. This procedure renames an existing file to a new name, similar to the UNIX mv function. Permission on both the source and destination directories must be granted. You can use the overwrite parameter to specify whether or not to overwrite a file if one exists in the destination directory. This procedure adjusts the file pointer forward or backward within the file by the number of bytes specified.
You must know the number of bytes by which you want to navigate. If the beginning of the file is reached before the number of bytes specified, then the file pointer is placed at the beginning of the file. This procedure reads text from the open file identified by the file handle and places the text in the output buffer parameter.
Text is read up to, but not including, the line terminator, or up to the end of the file, or up to the end of the len parameter. The number of bytes read from the file.
Default is NULL. Because the line terminator character is not read into the buffer, reading blank lines returns empty strings. With this function, you can read a text file in Unicode instead of in the database charset. The file must be open for reading mode r.
This function reads a RAW string value from a file and adjusts the file pointer ahead by the number of bytes read. This function tests a file handle to see if it identifies an open file. It does not guarantee that there will be no operating system errors when you attempt to use the file handle. This procedure writes one or more line terminators to the file identified by the input file handle. This procedure is separate from PUT because the line terminator is a platform-specific character or sequence of characters.
PUT writes the text string stored in the buffer parameter to the open file identified by the file handle. The file must be open for write operations. The file must be open for writing.
The sum of all sequential PUT calls cannot exceed without intermediate buffer flushes. This procedure writes the text string stored in the buffer parameter to the open file identified by the file handle.
With this function, you can write a text file in Unicode instead of in the database charset. See also "PUT Procedure". This procedure is a formatted PUT procedure. It works like a limited printf. This function accepts as input a RAW data value and writes the value to the output buffer. You can request an automatic flush of the buffer by setting the third argument to TRUE.
0コメント