CODEWITHSUNDEEP
sqlplus
Rookieslr
Rookieslr

Reputation: 1

SQL Plus closing after script is run

New to programming and SQL.

When I run a script within a SQL Plus command box window, the command window closes. How can I stop the script from closing the window automatically please?

First, I am logging into the DB host, then I run the script and I cannot tell what the output is, if it has errored, etc?

For example:

  1. Within Windows, run sqlplus
  2. login using 'schema/schemapassword@hostname
  3. run script using @c:\thisisanexampleofthescript.sql

At this point, the sql plus window closes

Thanks Brian

Upvotes: 0

Views: 684

Answers (1)

Romeo Ninov
Romeo Ninov

Reputation: 7265

To keep the window with sqlplus open first run cmd and then inside run sqlplus. Because sqlplus just close the window when it finish.

Upvotes: 1

Related Questions