Re: HELP: Change user in .SQL script

On Mon, 19 Jun 1995, Morgan Skinner wrote:
> The problem is that the machine halts after the first command ( I
> assume it is looking for a termination character or something like
> that). I have scripts that will do this from the command line, but I
> want to put all of this in one .SQL file.

You don't say what process you are feed these into. If it's SQLDBA the problem will be different than if it is SQLPLUS. So, what is going to process the SQL statements?

However, general rule of thumb requires a ';' at the end of each sql statement. For SQLPLUS you will need a '/' on a seperate line after each PL/SQL block.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+