ProC question

From: Kova'cs Zsolt <kzs_at_esa.atomki.hu>
Date: 1997/05/28
Message-ID: <338C0BDA.5605_at_esa.atomki.hu>#1/1


Hi everybody,
[Quoted] [Quoted] 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, 0,\
 SYSDATE, 2733, 0, 0, 0, 3, TO_DATE('26-May-1997, 12:26:26','DD-MON-YYYY, \
HH24:MI:SS'), TO_DATE('26-May-1997, 12:26:26','DD-MON-YYYY, HH24:MI:SS') , \

NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,
NULL, \
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL,\

 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL,\
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0);";

My ProC program compile very fine, but if I start my program after a login I get:

ORACLE error--  

[Quoted] ORA-00911: invalid character  

in "INSERT INTO CSC_RESULT_VECTORS VALUES (CSCRVR_SEQ.nextval, 0, SYSDATE,..."
on line 438 of .

Rem:

        If I send the same string to the sqlplus program everything is OK. Can somebody help me????

Zsolt Kovacs

-- 
Kovacs  Zsolt, physicist             Institut of Nuclear Research of	    
kzs_at_esa.atomki.hu                    the Hungarian Academy of
Science     
Tel: +36(52)417266                   H-4001 Debrecen, POB 51,
Hungary     
Fax: +36(52)413945                   (H-4028 Debrecen, Bem ter 18/C)
Received on Wed May 28 1997 - 00:00:00 CEST

Original text of this message