Wassup Fellas ...
Can anyone tell me, why this works:
EXEC SQL.
SELECT MAX(CHAVE)
INTO :l_chave1
FROM RBSTENVIO@CORP1_COML
ENDEXEC.
and this doesn`t ?
EXEC SQL.
INSERT INTO RBSTENVIO@CORP1_COML
(chave, uf, tipopesquisa, cnpjcpf, inscricaoestadual, cep,
razaosocial, pesquisado, habilitado)
VALUES (:l_chave1, :l_uf, :l_tpp, :l_cod,
:l_inscr, :l_cep, :l_razao, :l_pesq, :l_hab)
ENDEXEC.
The data base where the table RBSTENVIO exists is oracle. The connection is done with dblink.
The error is:
DBIF_DSQL2_SQL_ERROR
CX_SY_NATIVE_SQL_ERROR
Thx in advance.