SQLLDR - special chars in password

From: <brucejim_at_my-dejanews.com>
Date: Thu, 24 Sep 1998 16:03:24 GMT
Message-ID: <6udqgc$fm4$1@nnrp1.dejanews.com>

Any ideas how to resolve this problem? I have a ksh script on HPUX which uses SQL*Loader to load a table. The shell command is:

sqlload control=SAMPLE.CTL, userid=${ORAUSER}/${ORAPSWD}

The value of the $ORAPSWD variable is similar to this: sample#password

Receive error:
SQL*Loader: Release 7.3.2.3.0
SQL*Loader-925: Error while logging on to ORACLE (ulmconnect) ORA-01017: invalid username/password; logon denied

Problem seems to be the "#" character in password. I've tried to escape the password as in: sample\#password without success. Password cannot be changed due to a number of administrivial reasons.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 24 1998 - 11:03:24 CDT