When do scripts use plus80.exe and not sqlplus.exe? 1

[raygg]

Our small software development company distributes an interactive batch PL/SQL Oracle application we developed with 8.0.4 to customers who run 8.0.4, 8.0.5, or 8.0.6. It is not a web based app.

An Oracle DBA for a customer at a VERY LARGE manufacturing company called to complain that our script would not work on 8.0.5 because it is trying to execute sqlplus.exe, and she thought that on 8.0.5 it should be executing plus80.exe. This is new to us because we tested our installation on all three 8.0.4-5-6 and did not experience this problem.

Is it that at VERY LARGE companies they disable sqlplus.exe in favor of plus80.exe?

I noted that in 8.0.6, example, there are sqlplus.exe, plus80.exe, and plus80w.exe. What's the differences between these? [sig][/sig]

 

[carp]

I'm not sure that there's really any difference. For reasons still not clear to me, Oracle just decided to rename sqlplus to plus80 for a while; then it changed back to sqlplus. I HAVE noticed that if you install something else, such as Enterprise Manager, it reverts back to plus80. But even MORE bizarre is the fact that if you go to the DOS prompt (assuming a Windows platform) and enter sqlplus, a second DOS window opens up and plus80 gets invoked!
After poking around a bit, I found that it was just a problem with the PATH variable. Oracle included a sqlplus file that calls plus80. By placing my ORACLE_HOME/bin directory at the front of the PATH string, the problem went away.

Your customer might consider either changing PATH (if that will take care of it for them) or a file called sqlplus.bat that will call PLUS80. [sig][/sig]

 

[raygg]

Thanks for the quick reply [sig][/sig]