Re: Qn. regarding Oracle SQL
From: Joe Ahmann <ahmann_at_toucan.fs.com>
Date: Fri, 8 Apr 1994 18:23:01 GMT
Message-ID: <CnyDqD.GCv_at_cardinal.fs.com>
Date: Fri, 8 Apr 1994 18:23:01 GMT
Message-ID: <CnyDqD.GCv_at_cardinal.fs.com>
Vallabhdas Dinesh K (dkv0057_at_ucs.usl.edu) wrote:
: EXEC SQL WHENEVER NOT FOUND GOTO NOT_FOUND;
: EXEC SQL SELECT NAME, P.PHONE_NO
: INTO:p_name, :phone_no
: FROM PARTY
: WHERE LOG_NUM = :log_num
It should compile if you put a semicolon on the end of the select stmt. The compiler is just blowing off the end of the program.
-- -------------------------------------------------------------- Joe Ahmann ahmann_at_fs.com Fourth Shift Corp. (612) 851-1427 JIT Enterprise SystemsReceived on Fri Apr 08 1994 - 20:23:01 CEST