Home » Developer & Programmer » Forms » Schedule the form execution (oracle forms 6i)
Schedule the form execution [message #410451] Sat, 27 June 2009 02:12 Go to next message
shaz
Messages: 182
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 #410470 is a reply to message #410451] Sat, 27 June 2009 03:31 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
so u mean to say u want to schedule form?
Re: Schedule the form execution [message #410503 is a reply to message #410451] Sat, 27 June 2009 13:41 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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).
icon7.gif  Re: Schedule the form execution [message #411311 is a reply to message #410503] Fri, 03 July 2009 01:33 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
I have read about SQL Loader and also did some loading.
But, I have to do it in form itself.
Re: Schedule the form execution [message #411334 is a reply to message #411311] Fri, 03 July 2009 02:41 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.
Previous Topic: Send mail from Oracle Forms thro' Citrix Env.
Next Topic: Hierarchical Query for Employee
Goto Forum:
  


Current Time: Fri Dec 09 21:16:31 CST 2016

Total time taken to generate the page: 0.06649 seconds