Create entity does not return identity in Oracle external database

I have a problem and I can't solve it.

I have a "Create Entity" from an external Oracle database. I can insert the records normally, but I do not receive the identifier as a return.

My connection:


My application:


My problem:


What am I doing wrong?


Thank you

Hi Ricardo,

It is unclear to mee what DATA_INcluirAlterarVariavel does, you didn't share the implementation.

Regards,

Daniel

Hi Daniël, thanks for answering me.

This is the implementation

Daniël Kuhlmann wrote:

Hi Ricardo,

It is unclear to mee what DATA_INcluirAlterarVariavel does, you didn't share the implementation.

Regards,

Daniel

 Hi Daniël , thanks for answering me.

 

Still unclear, the assignment is what will tell me what returns the action.

I am including a record through a "create entity", but I don't get the return id.


The "CreateIBR_VARIAVEL" method was created automatically when I included the extension. He's not returning the identifier to me.


The extension is an external oracle database, where the primary key is generated through a sequence.

Data Module / Server Action : "DATA_IncluirAlterarVariavel"


Core Module / Server Action: "CORE_IncluirAlterarVariavel"


At this point, I can not retrieve the "Id" record

Solution

Hi,

The code looks good, It looks like you don't have set the Auto Generate checkbox on the entity definition in Integration Studio? So no new number is automatically generated by the database platform.

Regards,

Daniel

Solution

Perfect, Daniel.

Thanks so much for your help.


Regards ,

Ricardo Nunes