Home » Developer & Programmer » Forms » HOST command works in 2 workstations and fails in other 2
HOST command works in 2 workstations and fails in other 2 [message #249304] Wed, 04 July 2007 00:56 Go to next message
Messages: 1
Registered: July 2007
Junior Member

I am currently testing my Oracle Form. I issued a HOST command. It successfully executes in 2 PCs where i installed it, but fails to run in the other 2? what could be the reason for this?

Here are the details that might help:
1) Successfully ran in Windows NT
2) The other 2 PCs that failed running are in Windows 2000
3) The command is executed but no output was generated(or inserted in the table)
4) Here is the host command:
host(' sqlplus -s '||get_application_property(username)||'/'||get_application_property(password)||'@'||get_application_property(connect_string)||' @'||var.vV_sql_script||' apa_batch_process('||var.vN_batch_id||','''|| :control.as_of_date||''')')

WHERE: var.vV_sql_script = PATH&FILENAME of the sqlscript

Here is the hardcoded HOST command:
HOST(' sqlplus -s username/passwd@dbase Z:\path\crtbatchsql.sql apa_batch_process(14,'31-jan-2007'));

5) "Z:" is a mapped network drive which may be mapped differently by the other PC. So it is varies from pc to pc. But the 2 successful PCs both have it mapped as "Z:". The other two that failed, used "E:" and "F:".

I already added a text item so that the path can be changed if it is mapped differently.

6) Here is the form builder version I am using:
Forms [32 Bit] Version (Production)
Oracle8i Enterprise Edition Release - Production
With the Partitioning option
JServer Release - Production

Please help me on this. Thanks.

Re: HOST command works in 2 workstations and fails in other 2 [message #252739 is a reply to message #249304] Thu, 19 July 2007 18:48 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Previous Topic: how i can send value from one form to another
Next Topic: How to Filter a DB Data Block based on a column not in the Block
Goto Forum:

Current Time: Mon May 29 15:42:20 CDT 2017

Total time taken to generate the page: 0.07771 seconds