OraFAQ Forum: Forms » HOST command works in 2 workstations and fails in other 2

Home » Developer & Programmer » Forms » HOST command works in 2 workstations and fails in other 2

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

HOST command works in 2 workstations and fails in other 2 [message #249304]

Wed, 04 July 2007 00:56

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.

Report message to a moderator