Direct vs. Embedded call to SQL script

Hello all,

I have a SQL script named "script1.sql" which expects to receive 2 parameters (&1,&2).

I have noticed that when running the script directly from the command prompt (AIX Unix Environment), i.e. :

    sqlplus usr/pwd @script1 val1 val2

The results differ in comparison with embedding the following statement in "script2.sql":

    @script1 val1 val2

(in this case, running sqlplus usr/pwd @script2 produces various errors, which I do not know the reasoning for, such as ERROR, found DROP when expecting to find BEGIN...)

I would greatly appreciate any insights as to why this happens.

Many thanks,

Ariel Kirson
Ex Libris. Received on Thu Aug 06 1998 - 04:22:08 CDT