| Calling SQLLDR from Perl [message #73559] |
Fri, 21 May 2004 13:45  |
Asalm
Messages: 6
Registered: May 2004
|
Junior Member |
|
|
- Hi
Culd you please help fro your experiences?
I'm trying to call SQLLoader (SQLLDR) from Perl and need to know how to specify the Oracle directories within the script and execute the call.
I've experimented with this, firstly Perl is not recognising the sqlldr command and secondly in the call it's getting confused with the use @dbname in the call ie.
system('sqlldr cntl = main.ctl userid=peter/pwd123@dbname'); -
|
|
|
|
| Re: Calling SQLLDR from Perl [message #73575 is a reply to message #73559] |
Tue, 25 May 2004 05:05  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to use fully qualified paths; and escape all @ characters as one would normally do in Perl programs. Try the following:
system('/oracleHome/bin/sqlldr peter/pwd123@dbname control=/path/main.ctl');
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
