ProC question
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