Re: Breaking lines in Pro*C programs - Linux env RH AS 3.0 Oracle 9.2.4.0

raphael.duenas_at_agfa.com wrote:
> Hi,
>
> it's the first i try to compile pro*C programs with an Linux
> environment (Red hat AS 3.0), and my problem is the following :
>
> writing this :
>
> sprintf(lib_requete,
> "create table %s ( c_etablissement number(10) not
> null,\
> c_uf number(10) not null,\
> pos_uf number(10) not null, \
> pos_service number(10) not null)\
> tablespace concept_dyn\
> pctfree 10 pctused 40\
> initrans 1 maxtrans 255\
> storage (\
> initial 10K next 10K
> pctincrease 50\
> minextents 1 maxextents 100
> )\
> nocache",
> lib_tmp_upcr_dietix);
>
> I get this error :
>
> Error at line 357, column 1 in file myfile.sqlc
> c_uf number(10) not null,\
> 1
> PCC-S-02021, Found newline while scanning string literal
> Syntax error at line 357, column 33, file Dgenauto.sqlc:
> Error at line 357, column 33 in file myfile.sqlc
> c_uf number(10) not null,\
> ................................1
> PCC-S-02014, Encountered the symbol "\" when expecting one of the
> following:
>
> I've tried without "\" it's the same thing ?!?!
>
>
> Thanks in advance.
>
> Raphaël.

The backslash ("\") character is illegal in SQL. What happens if you leave it out?

HTH -g Received on Thu Sep 21 2006 - 11:37:53 CDT