| Schedule the form execution [message #410451] |
Sat, 27 June 2009 02:12  |
shaz
Messages: 104
Registered: June 2009 |
Senior Member |
|
|
hello all,
I am a fresher and I have created a form which uploads the csv (comma separated file) files to the oracle database.
Now, I have a requirement that I have to connect it to the scheduler so that csv should be uploaded to database at a short span of time automatically. Please guide me how can we do that.
I have searched on the net and i have grasped that the form needs to be attached to the schedule tasks which we see in control panel.... If anyone has any relevant matter or any suitable link please help.
|
|
|
|
| Re: Schedule the form execution [message #410503 is a reply to message #410451] |
Sat, 27 June 2009 13:41  |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
In my opinion, Forms is a wrong tool to load CSV files into a database. I'd rather use SQL*Loader which can easily be scheduled (as it is just another EXE so there's no problem in scheduling it using your operating system scheduling utility).
|
|
|
|
| Re: Schedule the form execution [message #411334 is a reply to message #411311] |
Fri, 03 July 2009 02:41 |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
How do you plan to do that?
If you manage to schedule a form, it will do - what? Open a form on that computer. Then what? It expects you to enter certain data, press a button, whatever. Who will do that? How will you schedule these actions?
OK, WHEN-NEW-FORM-INSTANCE trigger (for example) can do many things - initialize certain items, run a procedure etc. but ... I don't know, Forms is just a wrong tool to do that job.
|
|
|
] 
Members
Search
Help
Register
Login
Home
