How to break lines at Pro*C programs ? [message #87150] |
Fri, 10 December 2004 07:27 |
Jerry A. Gonçalves
Messages: 1 Registered: December 2004
|
Junior Member |
|
|
Hi,
In an Pro*C program, I´m trying use sprintf function passing an large string (it´s a sql statement).
I wrote that like this:
sprintf(MyVar, "select col1, n
col2, n
from my_table
where my_key = %s", param);
(My SQL statement is much more greater than this example)
But the compiler doesn´t accept this and return the following error message:
"PCC-S-02021, Found newline while scanning string literal"
How can I do this ?
Thanks in advance.
Jerry
|
|
|