OraFAQ Forum: Forms » Client_host on Oracle 11g(AIX)

Home » Developer & Programmer » Forms » Client_host on Oracle 11g(AIX)

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

Client_host on Oracle 11g(AIX) [message #583929]

Tue, 07 May 2013 03:20

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

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583932 is a reply to message #583929]

Tue, 07 May 2013 03:25

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I believe that CLIENT_HOST belongs to WEBUTIL. Did you install & configure it?

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583933 is a reply to message #583932]

Tue, 07 May 2013 03:26

sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore

Member

Yes. Webutil has been configured and other webutil related forms are working

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583936 is a reply to message #583933]

Tue, 07 May 2013 03:37

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

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583938 is a reply to message #583936]

Tue, 07 May 2013 03:39

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.

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583939 is a reply to message #583938]

Tue, 07 May 2013 03:45

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

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583940 is a reply to message #583939]

Tue, 07 May 2013 04:01

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

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #583942 is a reply to message #583940]

Tue, 07 May 2013 04:04

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Great, I'm glad you solved the problem!

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #587673 is a reply to message #583939]

Mon, 17 June 2013 23:23

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...

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #587677 is a reply to message #587673]

Tue, 18 June 2013 00:12

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

Report message to a moderator

Re: Client_host on Oracle 11g(AIX) [message #587710 is a reply to message #587677]

Tue, 18 June 2013 03:39

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.

Report message to a moderator

Previous Topic:	USB Finger Print Reader
Next Topic:	how to pick excel file and get data in form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:13:20 CDT 2024