Re: ProC question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/28
Message-ID: <339027de.2916643_at_newshost>#1/1

A semicolon ";" is not part of a sql statement. SQL*Plus uses it to determine the end of a sql statement, it is a sql*plus (and pl/sql) terminator but not valid SQL.

Take the semicolon out.

On Wed, 28 May 1997 12:41:30 +0200, Kova'cs Zsolt <kzs_at_esa.atomki.hu> wrote:

>Hi everybody,
>I'm just beginner in ProC and I use the following lines in a
>ProC program:
>
>EXEC SQL EXECUTE IMMEDIATE :kzs;
>
>where kzs is declared as
>(the length of string is 517 chars)
>
>
>char *kzs = "INSERT INTO CSC_RESULT_VECTORS VALUES (CSCRVR_SEQ.nextval,
 [snip]
>0);";
>

 [snip]
>
>ORA-00911: invalid character
>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 28 1997 - 00:00:00 CEST