Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLPLUS and SQLCL should have a batch mode to make it crash instead of hang

dirkvanhauteFeb 5 2020 — edited Feb 5 2020

Sqlplus and sqlcl are widely used for batch access to the database, in a service process running somewhere in the background.

They already have an option to fail after the first login attempt : -L

Otherwise, after a bad password, you would hang forever if you did not provide any input.

But also for other failures, an input is requested.  E.g. when you accidentally have substitutions who are not yet resolved.

These kinds of hangs are difficult to find, because you expect some database lock or slowness instead.

On fora, you will find a solution in redirecting the input from a file.
But it would be better if there is an command line option to put sqlplus or sqlcl in batch mode, that makes it fail when sqlplus is going to read from stdin.

Comments

Processing

Post Details

Added on Feb 5 2020
2 comments
668 views