OraFAQ Forum: Forms » how to exec file from forms dev........

Home » Developer & Programmer » Forms » how to exec file from forms dev........

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

how to exec file from forms dev........ [message #136274]

Wed, 07 September 2005 05:03

omidsm
Messages: 6
Registered: September 2005
Location: iran

Junior Member

hello
how to run sql commands in a file from forms developer in same session
because my tables is temporary tables

example of file
-------------------------------
insert into MISOWNER.EITMS (EITM_ITM, GUOM_GUOM_UOM, EITM_PRT_NUM)
values (321, 'ADD', '20393424');
insert into MISOWNER.EITMS (EITM_ITM, GUOM_GUOM_UOM, EITM_PRT_NUM)
values (323, 'ADD', '20393796');
insert into MISOWNER.EITMS (EITM_ITM, GUOM_GUOM_UOM, EITM_PRT_NUM)
values (324, 'ADD', '20393797');

Report message to a moderator

Re: how to exec file from forms dev........ [message #136392 is a reply to message #136274]

Wed, 07 September 2005 20:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

There are numerous answers and we need a bit more information on your requirements. To insert these three records everytime you run your form just put the 'insert' statements into your When-New-Form-Instance trigger.

David

Report message to a moderator

Re: how to exec file from forms dev........ [message #136481 is a reply to message #136274]

Thu, 08 September 2005 04:10

omidsm
Messages: 6
Registered: September 2005
Location: iran

Junior Member

this tree line is sample of file
this file generated by other programs
for convert data from excel file

how to open a file and run pl sql statments of into this file?plz

Report message to a moderator

Re: how to exec file from forms dev........ [message #136585 is a reply to message #136481]

Thu, 08 September 2005 18:43

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What version of forms are you using?

Search this forum for 'text_io' if using forms 4.5 or 6, or 'utl_file' if forms 6i or higher. Read, at least, three threads from top to bottom and then come back with specific questions.

David

Report message to a moderator

Re: how to exec file from forms dev........ [message #136754 is a reply to message #136274]

Fri, 09 September 2005 22:21

omidsm
Messages: 6
Registered: September 2005
Location: iran

Junior Member

tanks with helps
but how to run this read line?

Report message to a moderator

Re: how to exec file from forms dev........ [message #136848 is a reply to message #136754]

Sun, 11 September 2005 18:38

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What 'read line'?

Please give more details!!

David

Report message to a moderator

Re: how to exec file from forms dev........ [message #136862 is a reply to message #136274]

Sun, 11 September 2005 22:45

omidsm
Messages: 6
Registered: September 2005
Location: iran

Junior Member

when read one line from file this line is into text variable
how to run this text variable?

Report message to a moderator

Re: how to exec file from forms dev........ [message #136876 is a reply to message #136862]

Mon, 12 September 2005 01:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

More information please.

What version of Forms are you running? Client/server or 3-tier? Developer Server or Application Server?

Please detail in your post the code on which you are currently working.

Please give an example of text that you are reading.

We need ALL of this information to give you an answer.

David

Report message to a moderator

Previous Topic:	about triggers
Next Topic:	Look and feel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 14:47:47 CST 2025