Reading flat files from pl/sql

Pedro Hernandez

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

Jul 19 '05 #1

Subscribe Post Reply

6394

mcstock

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" <ph*****@yahoo.es> wrote in message
news:9d*************************@posting.google.co m...

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

Jul 19 '05 #2

Pedro Hernandez

"mcstock" <mc*************@spamdamenquery.com> wrote in message news:<AL********************@comcast.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

Jul 19 '05 #3

Similar topics

reading a declaration

by: Alan | last post by:

// C Pointer int y = 0; int* ptr = &y; Reads as "ptr is an integer pointer that points to (takes the address of) integer y". // C++ Reference int x = 0; int& ref = x;

C / C++

Flat file security

by: raykyoto | last post by:

Hi all, I'm sure this is a popular question that comes up every few months here. Indeed, I've looked at some of the past postings, but I would like to ask things differently. Basically, I'm...

PHP

Why XML config files?

by: Daniel Billingsley | last post by:

Ok, I wanted to ask this separate from nospam's ridiculous thread in hopes it could get some honest attention. VB6 had a some simple and fast mechanisms for retrieving values from basic text...

C# / C Sharp

Reading in data from very large flat files

by: booksnore | last post by:

I have to read data from a flat file with millions of records. I wanted to find the most efficient way of doing this. I was just going to use a StreamReader and then break up the input line using...

C# / C Sharp

Reading Flat Files to display queries in table format

by: eddieb7 | last post by:

Hi, I am new to visual Studio 2005 C++ and am looking for some directions on where best to start. I come from a mainly Delphi background and looking to switch to VS 2005 C++ or C#. I am...

C / C++

PHP flat file vs DB for a small website

by: Peter | last post by:

Greetings, I'm having trouble deciding on whether to go with a flat file or DB driven architecture for a wee personal website. I'd like to be able to update HTML files online and this is my only...

PHP

Validating flat files

by: anuanusha29 | last post by:

Hi, I am kinda new to programming and am in the process of implementing an application which is expected to parse/read data from flat files and display errors to the user about missing/invalid...

.NET Framework

Flat files and ASP.NET

by: =?Utf-8?B?TmF2YW5lZXRoLksuTg==?= | last post by:

Hello I am developing a system for user tracking. In this I am tracking all the visitors that came to my website. i developed this using a HTTPModule and storing the data in a SQL Server...

ASP.NET

create html from flat file

by: lxyone | last post by:

Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...

PHP

How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?

by: Tim | last post by:

Hi Folks, I'm used to a UNLOAD command that allows me to dump to a named flat file the results of any SELECT statement. Hence one can build a single SQL file which contains multiple SQL...

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware