OraFAQ Forum: Server Utilities » SQL Loader facility using Shell from Visual Basic

Home » RDBMS Server » Server Utilities » SQL Loader facility using Shell from Visual Basic

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

SQL Loader facility using Shell from Visual Basic [message #141584]

Tue, 11 October 2005 01:51

abmohan75
Messages: 7
Registered: October 2005

Junior Member

Hello All,

I am having Oracle 10i. If I run sqlldr from DOS prompt it is running without any problem. When I run from VB using shell command it is giving the following error.

Message 2100 not found; No message file for product=RDBMS, facility=UL

Can any one suggest for correcting this problem?

Thanks...

Regards,
Mohan.

Report message to a moderator

Re: SQL Loader facility using Shell from Visual Basic [message #141623 is a reply to message #141584]

Tue, 11 October 2005 06:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is to do with your environment settings.
Make you have the right path set.
ORACLE_HOME=your_oracle_home
PATH=$PATH:$ORACLE_HOME/bin

Report message to a moderator

Re: SQL Loader facility using Shell from Visual Basic [message #141990 is a reply to message #141623]

Thu, 13 October 2005 01:40

abmohan75
Messages: 7
Registered: October 2005

Junior Member

Hello Mahesh,

Already I had this path i.e C:\Oracle\product\10.1.0\Client_1 in my path. Now, according to your suggestion I created one system variable ORACLE_HOME=C:\Oracle\product\10.1.0\Client_1. Now it is working fine without any problem.

Thank you very much.

Regards,
Mohan

Report message to a moderator

Previous Topic:	can i pump the data from Ms-Excel to Oracle using sql loader?
Next Topic:	sqlldr non-ascii loading errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 06:17:12 CST 2024