Misterious Error in Pro*C

[Pedro Oguri]

On this piece of code:
When SELECT returns nothing sqlca.sqlcode = 0 and no_data_found_func
isn´t called.
How do I know if the insertion was OK?

EXEC SQL
INSERT INTO TB_SWITCH (
ID_SWITCH,
ID_SITE,
ID_PROPRIETARIO,
CD_OPC,
CD_SWITCH,
DS_TIPO_SWITCH,
DT_CRIACAO
)
(
SELECT
SQ_TBSWITCH.NEXTVAL,
s.id_site,
e.id_empresa,
:sw.cd_opc,
:sw.cd_switch,
:sw.ds_tipo_switch,
SYSDATE
FROM tb_empresa e, tb_site s WHERE
(s.cd_intelig_site = :sw.cd_intelig_site AND s.dt_exclusao IS NULL)
AND (e.nm_empresa = :sw.nm_empresa AND
e.dt_exclusao IS NULL)
AND ROWNUM = 1
);

if (sqlca.sqlcode != 0)
{
fprintf (fpLog, "Error on Insert\n", numReg);
}
}
sqlca.sqlcode is always 0.
How do I know if the insertion was OK, then?

Tks!

Pedro Oguri

[Mr McGeek]

Hi Pedro,

You should be able to use:

sqlca.sqlerrd[2]

Which will give you the number of rows processed by the last SQL statement

Cheers

Andy