CODEWITHSUNDEEP
vb.netoracle-databasesqlplus
Elena Akhmetova
Elena Akhmetova

Reputation: 21

Why Sql*plus was invoked when the application is running

Today I have received an email from clients who are testing our windows application. There is the question:"Sql*plus was also invoked during the testing activities. Is this executed from within the application?" I'm not a DBA so I have no answer. We don't call such execution within the application and the only thing I can assume that since we have a connection string to Oracle DB it can somehow be invoked during the connection to DB because sqlplus is a part of Oracle. Maybe it happens during the validation of credentials? Could you please give me the clear answer? Thank you in advance

Upvotes: 0

Views: 42

Answers (1)

ivanatpr
ivanatpr

Reputation: 1880

One can only speculate, but I'd bet that somewhere in your application a developer couldn't figure out how to do something via the ODBC/OLEDB driver and instead opted to execute a sql script by starting a sqlplus.exe process and feeding it command-line parameters. They probably forgot to set up the ProcessStartInfo so that UseShellExecute and CreateNoWindow are both set to false.

Upvotes: 2

Related Questions