SQL*Plus returning values to UNIX

We need to return a number to a Unix shell from Sql*Plus - this example results in errors:

ksh shell script: sqlplus user/password _at_test.sql

test.sql:             column concid new_value n_concid format 999
                      select my_sequences_s.nextval concid
                         from dual;
                      exit n_concid;

Any Idea why echo $? would return the wrong value in the shell script?
Please respond by mail. Thanks Received on Wed Jul 28 1993 - 15:22:00 CEST