| Load text data into database table with Apex [message #467192] |
Thu, 22 July 2010 10:27  |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Hi I need to load text data into Oracle database tables with Apex. Is there any way to do that? I am basically a Oracle Form developer. I have done that very easily in forms. Now I have been gradually moving to apex development. Now in one of my developments I need to read text data with specific data format and insert data in the corresponding table. Please if any help is there have a post here.
Regards
Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka, Bangladesh
|
|
|
|
|
|
|
|
| Re: Load text data into database table with Apex [message #486983 is a reply to message #486972] |
Tue, 21 December 2010 22:24  |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Hi Roderic, thanks for the reply. I have seen the Utilities, if you notice that this facility is for developer/admin users only and at the development environment, not for the end users at runtime environment. My requirement is, I want to provide an interface/page to the end users. Usres will browse the required file with required format and select the file, where each line represents a record of a table. After end user selects the file the system will go through the entire file and insert each record into the database table. Remember not upload the file itself, only the record of the file will be inserted. Please notify any idea.
Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka, Bangladesh
|
|
|
|
|
|
| Re: Load text data into database table with Apex [message #487275 is a reply to message #487190] |
Fri, 24 December 2010 09:24 |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Hi Thanks for the link. I have checked the solution. I think it will just work. But if you go farther and like to implement in a commercial solution it should offer much more than that. The process here is you have to upload the file into your apex repository first, then you call the file from wwv_flow_files table and do some very difficult things to insert into the table. OK. I accept that. But what about error handling?? Say there is some errors in the data in the file you uploaded. Errors may unique key constraint error, referential integrity constraint errors, data format error and so on..Now if you want to generate an error file containing error messages so that the data insertion is not hampered untill the full file is read. There is no such solution here. Ok if this the solution Oracle Apex has to offer then I am shocked!! I think Oracle is smarter than that. Coz I have handled the situation in One of my Forms 6i Application five years ago. Oracle Apex might have some other solution to handle this.
Regards
Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka, Bangladesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
