topic Re: EXEC SQL in Application Development and Automation Discussions

EXEC SQL

Former Member — Wed, 28 Jan 2009 10:30:08 GMT

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.

Re: EXEC SQL

Former Member — Wed, 28 Jan 2009 15:48:44 GMT

I solved the problem.

Thx to myself.

10 points to me.

If u read this and need help, contact me.

Re: EXEC SQL

Former Member — Wed, 25 Feb 2009 15:30:36 GMT

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.