Home » Developer & Programmer » Forms » Client_host on Oracle 11g(AIX)
Client_host on Oracle 11g(AIX) [message #583929] Tue, 07 May 2013 03:20 Go to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Hi,
We are migrating Forms 6i to 11g(On AIX)
I replaced an HOST command by client_host as
client_HOST('start "" "'||v_url||'/SearchMovement?label=001&appl='||'OMS'||'&clex='||:OMS_CLIENT_EXECUTIONS.IDE_CLEX|| '"',NO_SCREEN);
When i am running the Form locally using the cmd
HOST('start "" "'||v_url||'/SearchMovement?label=001&appl='||'OMS'||'&clex='||:OMS_CLIENT_EXECUTIONS.IDE_CLEX|| '"',NO_SCREEN);
then it works perfectly.

But when i use client_host then it returns sqleerm=100501.
Kindly help me fix this
Re: Client_host on Oracle 11g(AIX) [message #583932 is a reply to message #583929] Tue, 07 May 2013 03:25 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that CLIENT_HOST belongs to WEBUTIL. Did you install & configure it?
Re: Client_host on Oracle 11g(AIX) [message #583933 is a reply to message #583932] Tue, 07 May 2013 03:26 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Yes. Webutil has been configured and other webutil related forms are working
Re: Client_host on Oracle 11g(AIX) [message #583936 is a reply to message #583933] Tue, 07 May 2013 03:37 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
sqleerm=100501 indicates a non-Oracle error. Unfortunately, I don't know AIX and don't use Webutil so ... sorry, someone else will have to assist you about that.
Re: Client_host on Oracle 11g(AIX) [message #583938 is a reply to message #583936] Tue, 07 May 2013 03:39 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
If you help me figure why this is not running on Windows, i.e when i am running it locally then that would also help.
Re: Client_host on Oracle 11g(AIX) [message #583939 is a reply to message #583938] Tue, 07 May 2013 03:45 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As these procedures run executables on a sever (HOST) or a client computer (CLIENT_HOST), make sure that it is correctly written (such as: put the whole command into a local variable and display it on the screen using the MESSAGE built-in); copy-paste it to a client computer and try to run it from its command prompt. If it works OK, fine - it is most probably OK. If it doesn't, operating system will tell you why it won't work and these hints might help you fix it.
Re: Client_host on Oracle 11g(AIX) [message #583940 is a reply to message #583939] Tue, 07 May 2013 04:01 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Thanks for your inputs.
I was able to fix the issue by few changes in the code Smile
I had to include cmd in my variable and it works fine now
Thanks again Smile
Re: Client_host on Oracle 11g(AIX) [message #583942 is a reply to message #583940] Tue, 07 May 2013 04:04 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Great, I'm glad you solved the problem!
Re: Client_host on Oracle 11g(AIX) [message #587673 is a reply to message #583939] Mon, 17 June 2013 23:23 Go to previous messageGo to next message
saisandeept
Messages: 16
Registered: May 2013
Location: chennai
Junior Member
hi sankalputtara,i am also migrating forms 6i to 11g.
i am also facing same problem,please give the changes you have made.and provide sample coding also.
thank u...
Re: Client_host on Oracle 11g(AIX) [message #587677 is a reply to message #587673] Tue, 18 June 2013 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 19321
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I understood, he had put directory that contains the CMD executable into the PATH environment variable.

Hopefully, he'll explain it later, providing more details.
Re: Client_host on Oracle 11g(AIX) [message #587710 is a reply to message #587677] Tue, 18 June 2013 03:39 Go to previous message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Hi,
You can use web.show_document or as Littlefoot suggested i had put directory that contains the CMD executable into the PATH environment variable.
Previous Topic: USB Finger Print Reader
Next Topic: how to pick excel file and get data in form
Goto Forum:
  


Current Time: Tue Jul 29 03:23:29 CDT 2014

Total time taken to generate the page: 0.08965 seconds