Skip to Content
0
Former Member
Jan 28, 2009 at 10:30 AM

EXEC SQL

40 Views

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.