Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2041
  • Last Modified:

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
0
senexpert
Asked:
senexpert
1 Solution
 
schwertnerCommented:
TEXT_IO are available only in Forms and Reports.
UTL_FILE works only on the server.
To read a file on the client and to store it on the server create a stored procedure with UTL_FILE on the server and call it from Forms. The local file can be read using TEXT_IO.
0
 
Mark GeerlingsDatabase AdministratorCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now