Re: SQL*Loader Install Problem

I'm assuming that when you mean SQL prompt, you mean the prompt that you get when you run SQL*Plus. The SQL prompt accepts only SQL, PL/SQL and (if using SQL*Plus) SQL*Plus commands. sqlldr is not any of these types of commands. It is in fact a completely different product.

I don't know too much about Personal Oracle7, but if the SQL*Loader packaged with this works anything like the UNIX versions, go to the MS-DOS prompt and invoke sqlldr from there. On the UNIX versions of SQL*Loader, if you just type "sqlldr", what you get is an explanation of the parameters that you have to pass sqlldr. What you described in 3 below sounds a bit like it might be doing that.

Stephen L. Surdu wrote:
>
> I purchased Personal Oracle/7 for Windows 95 and have been able use the
> product without incident. However, I tried to execute SQL*Loader with
> the command "sqlldr" at the SQL prompt and the command is not
> recognized. I've tried to obtain e-mail support from Oracle but I'm not
> getting a response. Can someone answer several questions for me?
>
> 1. Should I be able to invoke SQL*Loader from the SQL prompt or should I
> be executing it from elsewhere?
> 2. I have checked the Oracle web page where they say SQL*Loader(and
> SQLDBA) are 16 bit applications that need you need to perform a
> special install from the Windows directory on the install CD. I have
> tried to execute it but it does not display any products in the
> install window to select. It sounds like a bad CD to me or am I
> doing something wrong?
> 3. My original 32 bit install from the CD shows executables for
> SQL*Loader and SQLDBA in the orawin95\bin directory. When I click on
> SQLDBA I obtain a screen I can execute SQLDBA commands from. When I
> click on the SQL*Loader executable a DOS screen displays, a number of
> commands execute and then the DOS window closes. Can I somehow
> execute SQL*Loader if this executable is installed?
>
> Please post a response, or even better, drop me an e-mail at
> slsurdu_at_mich.com. I'm planning on developing a search engine type of
> service accessible through the internet and I would be thankful to have
> individuals to trade ideas with.
>
> Thanks - in advance.
>
> Steve Surdu
 

-- 
                  ____________________________________________ 
                 /    Kenichi Mizuta 
      ////      /     Oracle Corporation (Redwood Shores, CA) 
     |0 0|     /      Applications Division 
_ooO_ \U/_Ooo_/       email: kmizuta_at_us.oracle.com 
The comments and opinions expressed herein are mine and
do not necessarily represent those of Oracle Corporation.