Home » Developer & Programmer » Forms » HOW CALL BATCH FILE FROM FORMS 10G
icon4.gif  HOW CALL BATCH FILE FROM FORMS 10G [message #357644] Thu, 06 November 2008 02:27 Go to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
CAN ANY ONE HELP ME AND TELL ME HOW TO CALL BATCH FILE FROM FORMS 10G
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #357662 is a reply to message #357644] Thu, 06 November 2008 03:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
HOST built-in?
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #357835 is a reply to message #357662] Thu, 06 November 2008 21:19 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Or 'Client_Host'.

David
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #357939 is a reply to message #357644] Fri, 07 November 2008 05:45 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
thank you,
but i want to run this batch file in the server not the host
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #357948 is a reply to message #357644] Fri, 07 November 2008 06:16 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
i tied to use host but it did not work
can you try it
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #358177 is a reply to message #357948] Mon, 10 November 2008 00:28 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What did you run? What did it do? It runs in a new session, did you set the session defaults?

David
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #358252 is a reply to message #358177] Mon, 10 November 2008 06:15 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
i want to run batch file that contain this command
rman target / cmdfile='C:\oracle\product\10.2.0\flash_recovery_area\TXT.BAT'
the txt.bat file contain
command like
backup as backupset database ;
and thank you again
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #358538 is a reply to message #358252] Tue, 11 November 2008 18:36 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does your response mean that you have solved your problem?

David
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #358658 is a reply to message #358538] Wed, 12 November 2008 01:41 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
no
i mean ,i tried all ways even that way
and the batch file did not run
do you know why?
and what is the correct way to run batch file?
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #358920 is a reply to message #358658] Thu, 13 November 2008 00:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post your code and use 'code' tags.

David
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #359250 is a reply to message #358920] Fri, 14 November 2008 06:18 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
thanks i find the solution
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #359260 is a reply to message #359250] Fri, 14 November 2008 07:48 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That is really nice.

However, people who will read this thread in the future would certainly love to see the way you managed to do the job. Therefore, would you mind to post the solution (or, at least, explain what you did in order to make it work)?
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #359262 is a reply to message #359260] Fri, 14 November 2008 07:55 Go to previous messageGo to next message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
no thing ,
forms 10g can not do backup command,
when i changed the content of the batch file to exp command it works correctly
i asked about it an expert oracle developer and he tell me the same information.
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #359415 is a reply to message #359262] Sat, 15 November 2008 13:48 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i want to run batch file that contain this command
rman target / cmdfile='C:\oracle\product\10.2.0\flash_recovery_area\TXT.BAT'
the txt.bat file contain command like
 
backup as backupset database;


So, are you saying that the above code just won't work when called by the HOST built-in from Forms 10g?

I'm not familiar with RMAN and, therefore, am reluctant to experiment on my database (wouldn't want to screw something up). Yes, I know, there's documentation which would explain what it is supposed to do but it certainly takes time which I am not ready to spare at the moment.

Perhaps someone who knows such things can test it; I might, however, ask fellow Forum members to suggest a "harmless" RMAN backup statement and I'll try it.

Because, I somehow refuse to believe that HOST can't start such a command. After all, it is yet another operating system command (comes from Oracle, true, but still an operating system command).
Re: HOW CALL BATCH FILE FROM FORMS 10G [message #359454 is a reply to message #359415] Sun, 16 November 2008 10:27 Go to previous message
ENG1_MAIADA
Messages: 8
Registered: November 2008
Location: EGYPT
Junior Member
i did not read any documentation ,just asking an oracle developer expert and he tell me these information
oracle forms work correctly with expdb and impdb
and tell me when you try it

[Updated on: Sun, 16 November 2008 10:29]

Report message to a moderator

Previous Topic: open form in 10g
Next Topic: Problem opening form module from another form module
Goto Forum:
  


Current Time: Tue Feb 18 00:30:07 CST 2025