EXEC SQL

[Former Member]

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.

[Former Member]

I solved the problem.

Thx to myself.

10 points to me.

If u read this and need help, contact me.

[Former Member]

Someone mind commenting on what the problem was here? I am doing something very similiar, and I am coming up with similiar issues. I appreciate the help in advance.