priyanka kulkarni
asked on
Oracle form 10g,Reading text file
In oracle form 10g,I have implement one task,I have to read text file and extract the useful data like name DOB CRN no etc and display it on form,i have to create LOV of CRN no which is present only in text file,
,if we choose CRN no then form should display information related to that CRN
My thought on it
1)create procedure to read file and extract data put it on temp table
2)used that temp table in oracle from to create LOV and display information
Can you please suggest me on this? is there any other way to do that
Thank you
,if we choose CRN no then form should display information related to that CRN
My thought on it
1)create procedure to read file and extract data put it on temp table
2)used that temp table in oracle from to create LOV and display information
Can you please suggest me on this? is there any other way to do that
Thank you
As flow01 suggested, there are multiple ways to do this, depending on where the text files will be. Will they be on:
1. a client PC
2. the Oracle Forms application server
3. the database server
The approach to use is different for each one of these.
1. a client PC
2. the Oracle Forms application server
3. the database server
The approach to use is different for each one of these.
ASKER
Will check all possibilities if any help required will come back :)
thank you.
thank you.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
1. You can use text_io(text_file on server, procedure in oracle_forms), CLIENT_TEXT_IO (text_file on client, webutil needed, procedure in oracle_forms), utl_file(text_file on server, procedure in database), external_table (text_file on server, procedure forms or database), DBMS_LOB.LOADFROMFILE (text_file on server, procedure in database) to access the text-file.
You can store the data of the text-file directly in a record_group (oracle_forms), in a temporary table (database) and refer to that table in the recordgroup, a pl/sql-collection in a database_package and refer to that collection bij using a (pipelined) table-funtion.