Search Results

The solutions that have been suggested will work fine, so long as the length of the filename does not vary. If it does, then you need a different solution.

One possibility is this:
...

Just to update you on this problem. I did implement the suggestion of listening for a specific string that indicates the completion of a SQL command. It did improve the runtime of the job, but only...

Actually, you did a pretty good job of speaking for me :-). Some of the benefits of using a coprocess apply in my world too. I too support an application (actually two of them) that uses multiple...

Jim

That sounds far too simple and sensible.

Actually, the reason why I don't do this is that I want to run a series of SQLPlus commands in a single session, and exit when the first error...

Thanks for responding. It looks like a little experimentation is in order here. I'll try your suggestion of using PRINT in SQLPlus and let you know what happens.

I am wracking my brains over this. I am trying to use a Korn Shell script to execute an Oracle PL/SQL procedure, using the Oracle command line interface (sqlplus). The script starts sqlplus in a...