senexpert
asked on
TEXT_IO Package in Oracle 8i
Guys ,
I have to read a file in client machine and to copy to server machine in a directory which is shared ..
To Copy to Server , I can use UTL_FILE and for client file operations , I thought of using TEXT_IO and I couldn't find the package ( I am using Oracle 8i) , can anyone guide me where can I download the Text_IO package like we do to compile the UTL_FIL which will be in the oracle \ rdbms \ admin folder.
With Thanks .
Sen
I have to read a file in client machine and to copy to server machine in a directory which is shared ..
To Copy to Server , I can use UTL_FILE and for client file operations , I thought of using TEXT_IO and I couldn't find the package ( I am using Oracle 8i) , can anyone guide me where can I download the Text_IO package like we do to compile the UTL_FIL which will be in the oracle \ rdbms \ admin folder.
With Thanks .
Sen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As schwertner indicated, TEXT_IO is only available if you have Oracle Forms or Oracle Reports running in client/server mode on the clients. If you have different client software (or Oracle Forms running from a web server), you will need to use a different utility or file copy mechanism to copy the text file(s) to the server. A simple DOS file copy command could do this, and that could be executed via a batch file. Other options may be available too depending on your client software.
http://www.dbasupport.com/oracle/faq/Detailed/346.shtml
look at here also..
https://www.experts-exchange.com/questions/20456408/Mimic-OLE-or-TEXT-IO-in-Oracle-Web-enabled-Forms.html
R.K