| host/SQL*Loader oddity [message #176046] |
Tue, 06 June 2006 10:16  |
sciolist
Messages: 4
Registered: June 2006
Location: Cambridge, UK
|
Junior Member |
|
|
Hello,
I'm running Oracle Forms 10.1.2.0.2 on Windows 2003 server. Database is 10.2.0.1.0 on the same windows server.
When I run SQL*loader from the command line on the server it works and loads the correct number of rows into the appropriate table.
sqlldr USERID=scott/tiger@d_test01 CONTROL=e:\wcmc\cites\data\TSD.ctl log=e:\wcmc\cites\data\load.log rows=1 errors=500
When called from a simple test form using host, it does not work.
host('sqlldr USERID=scott/tiger@d_test01 CONTROL=e:\wcmc\cites\data\TSD.ctl log=e:\wcmc\cites\data\load.log rows=1 errors=500');
Am I missing something really obvious? Is host the correct command to use to embed a sqlldr operation into a form?
Thanks,
S
|
|
|
|
| Re: host/SQL*Loader oddity [message #176428 is a reply to message #176046] |
Thu, 08 June 2006 05:24  |
gacki
Messages: 33
Registered: May 2006
Location: Dueren, NRW, Germany
|
Member |
|
|
First of all keep in mind that the HOST built-in is always executed on the server!
For windows system I guess that you have to place 'cmd' before the command like this:
host('cmd /C sqlldr USERID=scott/tiger@d_test01 CONTROL=e:\wcmc\cites\data\TSD.ctl log=e:\wcmc\cites\data\load.log rows=1 errors=500');
Gerald
|
|
|
|
|
|
| Re: host/SQL*Loader oddity [message #176736 is a reply to message #176608] |
Fri, 09 June 2006 06:20 |
sciolist
Messages: 4
Registered: June 2006
Location: Cambridge, UK
|
Junior Member |
|
|
Thanks for the responses.
'cmd /c sqlldr ...' etc fails in a similar way.
We have no proper AS as such. The Forms 'AS' web distribution is installed on the same physical server as the Database machine. Is that bad/dangerous?
Fail symptom is ... absolutely nothing happens. I click the button that has the host command in its WBP trigger. zip, zero, nada.
The UI shows me the graphic of the button being depressed, but no command is run, no logs produced. When that sqlldr command is run from cmd on the AS machine, sqlldr runs as expected producing log files.
Does Forms require additional permissions somehow to access the server directory structure or paths? (Forms_path is set to include location of the sqlldr executable). Attached is my blindingly simple test-form, in case you feel inspired to fiddle with it.
-
Attachment: HOST_TEST.fmb
(Size: 112.00KB, Downloaded 1013 times)
[Updated on: Fri, 09 June 2006 06:22] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
