Re: SQL*Loader-128: unable to begin a session after changing the password

From: <fitzjarrell_at_cox.net>
Date: 20 Jan 2005 11:24:13 -0800
Message-ID: <1106249053.710054.116360@z14g2000cwz.googlegroups.com>

Diana wrote:
> I run a stored procedure that calls the sqlldr as host command to
load data.
> I use always the same user. now I have changed the password of the
user
> (alter user) and the password in the host command used in the stored
procedure.
> Before the procedure works fine, but now I get the following errors:
>
> SQL*Loader-128: unable to begin a session
> ORA-01017: invalid username/password; logon denied
>
> what I have to do?
> thanks for your help.

Are you able to run SQL*Loader from the command line with the user and password from the stored procedure?

David Fitzjarrell Received on Thu Jan 20 2005 - 13:24:13 CST