Re: ProC question

Kova'cs Zsolt 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,
> 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--
>
> 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)

For one thing, I think you need to remove the semicolon at the end of the command string.

-Peter Sylvester
MITRE Corp. Received on Wed May 28 1997 - 00:00:00 CEST