RE: UTL FILE PKG

From: Dasko, Dan <Dan.Dasko_at_cdicorp.com>
Date: Wed, 14 Feb 2001 11:12:54 -0800
Message-ID: <F001.002B465A.20010214110817@fatcity.com>

Can forms read the machine name from the registry?

-----Original Message-----
Sent: Wednesday, February 14, 2001 1:42 PM To: Multiple recipients of list ORACLE-L

Thanks for the reply.
Well, the file will has to sit on the client machine. In a bank where they are doing transaction over the counters, the system got to know which machine is which bank counter. So the system reads the file from the hard disk to find out the counter. So as you might notice this has to happen without any user interaction. I thought of keeping the network addresses against each counter in the database. But it can't be done because of the IP addresses can change dynamically.

any ideas would be appreciated
TIA
Alroy

• Bill Pribyl <bill_at_datacraft.com> wrote: > > WE want to read a file which is in a client
  > machine
  > > thru UTL_FILE is it possible ?
  > > We have to do this because forms ( ver 5) can't
  > read
  > > a file in the client when it is run through the
  > oracle
  > > web server.
  >
  > UTL_FILE can only read files on the machine where
  > the oracle server is
  > running. If your client can publish a filesystem
  > (say, via NFS) that you
  > can mount on the oracle server machine, you may be
  > able to use UTL_FILE.
  > But since you are talking about Forms I don't
  > imagine this is an option to
  > you. Also, using UTL_FILE is not very secure (of
  > course, neither is NFS)
  > and a lot of people who try to use it get pretty
  > frustrated. I think some
  > oracle 8.1+ sites are instead using the file I/O
  > features of Java via (Java
  > stored procedures) to read and write files on the
  > database server machine.
  >
  > If the file is small you may be able to have the
  > user upload it to the
  > server via an HTML form (but you can't upload a file
  > without some specific
  > user action) or maybe via some Java applet. As far
  > as I'm concerned, the
  > HTML method relatively easy (also it is tried and
  > true). You have to jump
  > through a bunch of hoops to authorize Java to read a
  > file, though.
  >
  > I suppose, though I've not done it, that Oracle's
  > new "iFS" (Internet File
  > System) might also provide a solution to the general
  > problem of reading
  > files from client machines into the database, maybe
  > someone on the list
  > could comment there..
  >
  > Just curious, what is the function of the file?
  >
  > Good luck
  > Bill
  > --
  >
  > ______________________________________________
  > http://www.datacraft.com/ http://plnet.org/
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Bill Pribyl
  > INET: bill_at_datacraft.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Alroy=20Mascrenghe?=
  INET: mark_alroy_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

_____________________________________________________________________
This message has been checked for all known viruses by UUNET delivered 
through the MessageLabs Virus Control Centre. For further information visit
http://www.uk.uu.net/products/security/virus/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  INET: Dan.Dasko_at_cdicorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 14 2001 - 13:12:54 CST