Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Oracle only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Today's Posts
Member List
Calendar
Home
Forum
Topic
Oracle
Reading flat files from pl/sql
Collapse
This topic is closed.
X
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
Pedro Hernandez
#1
Reading flat files from pl/sql
Jun 27 '08, 05:31 PM
This might seem strange, but I would like to know if it is possible to
open a text file (for reading) from pl/sql.
Ora8i on RHL7.3
Thanks,
ph
mcstock
#2
Jun 27 '08, 05:31 PM
Re: Reading flat files from pl/sql
from a stored PL/SQL procedure? yes, as long as it's on the database
erver -- look into the UTL_FILE package
or are you referring to reading a file from the client machine? if so,
what's your development tool?
note that in 9i you could also look into external tables (MetaLink note
Note:150740.1)
-- mcs
"Pedro Hernandez" <phph109@yahoo. eswrote in message
news:9d013a92.0 311131124.8474b ef@posting.goog le.com...
This might seem strange, but I would like to know if it is possible to
open a text file (for reading) from pl/sql.
>
Ora8i on RHL7.3
>
>
Thanks,
ph
Comment
Post
Cancel
Pedro Hernandez
#3
Jun 27 '08, 05:32 PM
Re: Reading flat files from pl/sql
"mcstock" <mcstockspamplu g@spamdamenquer y.comwrote in message news:<ALGdnSjOe f7YQy6i4p2dnA@c omcast.com>...
from a stored PL/SQL procedure? yes, as long as it's on the database
erver -- look into the UTL_FILE package
Thats it, thanks a lot!
ph
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment