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
orafaqjannie
Messages: 1
Registered: July 2007
Junior Member
Hi..


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 6.0.5.0.2 (Production)
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - 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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
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: Sat Dec 10 03:12:22 CST 2016

Total time taken to generate the page: 0.08935 seconds