Home » Developer & Programmer » Forms » HOST function in forms 9i
HOST function in forms 9i [message #208487] Mon, 11 December 2006 01:08 Go to next message
verkiles
Messages: 15
Registered: November 2006
Location: Philippines
Junior Member

I try using forms 9i and i noticed that host function doesn't perform. like calling shellscript or sqlplus.

Please help me work this out.

THanks,
Re: HOST function in forms 9i [message #208665 is a reply to message #208487] Mon, 11 December 2006 19:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the error that you are getting? Are you trying to run on the client PC or the Application Server?

David
Re: HOST function in forms 9i [message #208672 is a reply to message #208665] Mon, 11 December 2006 20:14 Go to previous messageGo to next message
verkiles
Messages: 15
Registered: November 2006
Location: Philippines
Junior Member

I cannot see the error. I try to use the form_success rigth after issue the command HOST('test.shl') and i got a failed result.

Am running it in AS.

Thanks for you help!.

Re: HOST function in forms 9i [message #208684 is a reply to message #208672] Mon, 11 December 2006 21:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you know in which directory you are running when you run the host command? Do you know the environment variables that the host command has available to it?

Remember that the host command uses a NEW session.

David
Re: HOST function in forms 9i [message #208981 is a reply to message #208487] Tue, 12 December 2006 18:59 Go to previous messageGo to next message
verkiles
Messages: 15
Registered: November 2006
Location: Philippines
Junior Member

I try to find the host command if its available and i did not find it.
What's the best i can do now?

THanks,
verkiles
Re: HOST function in forms 9i [message #208993 is a reply to message #208981] Tue, 12 December 2006 21:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Of course the 'host' command is available.

In a When-Button-Pressed trigger put something like "host('pwd > /tmp/aaa.txt');", compile and run the form, press the button, and then look in the '/tmp' directory for the file 'aaa.txt' and read it.

David
Re: HOST function in forms 9i [message #208994 is a reply to message #208487] Tue, 12 December 2006 21:33 Go to previous messageGo to next message
verkiles
Messages: 15
Registered: November 2006
Location: Philippines
Junior Member

this is what it says in the text when i did what you told me:

/u01/oracle/tmxora/OraPortal_904/forms90

Why do i get a failed result when i issue the function form_success after i issue the host command?..

THanks for your help david.
Verkiles
Re: HOST function in forms 9i [message #208995 is a reply to message #208487] Tue, 12 December 2006 21:45 Go to previous messageGo to next message
verkiles
Messages: 15
Registered: November 2006
Location: Philippines
Junior Member

The script also that i want to execute using host command doesn't execute.

Thanks!
Re: HOST function in forms 9i [message #209005 is a reply to message #208995] Tue, 12 December 2006 22:33 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You keep saying that it "doesn't perform" and it "doesn't execute" but you don't tell us either what is the failure message or the output text or the script that you are running. Direct the standard and 2 output to files, post your script and post the standard and 2 output.

If you sign on to your Application Server as 'oracle' and go to the directory '/u01/oracle/tmxora/OraPortal_904/forms90' will your script run successfully?

David

[Updated on: Tue, 12 December 2006 22:34]

Report message to a moderator

Previous Topic: I have a little problem with the default exit button..
Next Topic: sequence is not generating number in sequence
Goto Forum:
  


Current Time: Fri Dec 09 03:54:33 CST 2016

Total time taken to generate the page: 0.08077 seconds