OraFAQ Forum: Forms » Schedule the form execution

Home » Developer & Programmer » Forms » Schedule the form execution (oracle forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Schedule the form execution [message #410451]

Sat, 27 June 2009 02:12

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.

Report message to a moderator

Re: Schedule the form execution [message #410470 is a reply to message #410451]

Sat, 27 June 2009 03:31

kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India

Member

so u mean to say u want to schedule form?

Report message to a moderator

Re: Schedule the form execution [message #410503 is a reply to message #410451]

Sat, 27 June 2009 13:41

Littlefoot
Messages: 21818
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).

Report message to a moderator

Re: Schedule the form execution [message #411311 is a reply to message #410503]

Fri, 03 July 2009 01:33

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.

Report message to a moderator

Re: Schedule the form execution [message #411334 is a reply to message #411311]

Fri, 03 July 2009 02:41

Littlefoot
Messages: 21818
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.

Report message to a moderator

Previous Topic:	Send mail from Oracle Forms thro' Citrix Env.
Next Topic:	Hierarchical Query for Employee

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:40:04 CDT 2024