Tag Info

The solution must be on 19c. It will end up on Kafka. GG is probably not an option due to licencing because I'm not the owner of the database nor data. I just provide an aplication to multiple clients....

Yes, this is solution 4. But I'm worried about context switching overhead for large message batches and for example index contention when I simultaneously via trigger insert new records to be exported ...

Your problem's definition is called CDC (Continuous data capture). You can use Golden Gate, Shareplex, OpenLogReplicator or native Oracle Kafka support(since ver 23ai). And several other tools. Do not ...

I suggest you try a different scenario. You could create a separate table for outgoing messages. You insert records into it when a message is updated or inserted (the trigger you described at the ...

Below is the PL/SQL function code CREATE OR REPLACE FUNCTION glm_get_routing_gmlstage (v_factory IN VARCHAR2, v_s4MPN in VARCHAR2, v_legacystage in VARCHAR2, v_facility in VARCHAR2) RETURN VARCHAR2 IS ...

Please add the query, which returns duplicate rows, to the question above.

yes but how to return the exact step when I have multiple 4210 record, currently it returns B234210 twice, by right it should return B234210, another one is B254210

Using ROWID is best where duplicate data exists and no other key fields are available.

First of all: use IntelliJ community edition. Don't use Visual Studio Code. I don't know why people default to that nowadays, it's not built for Java programming. You'll slow yourself down trying. You ...

If you're familiar with databases already, then after some basics (OOP and such), I suggest you take a look at some overviews in 'Java Persistence API (JPA)' as well. Gives you some kind of idea how ...

For learning Java in general — assuming you are not familiar with the language — I suggest Oracle's Java tutorials.

true, however this might be because the company didn't specify what. JDBC is very ... crude, usually, companies won't let their developers manually code everything anymore, especially since hibernate ...

I would suggest reading through the material at dev.java - and perhaps message them for details on which version control they use (it's probably Git, but you know what they say about assumptions), ...

Autonomous DBs on OCI supports several network, but rules on https://docs.oracle.com/en-us/iaas/autonomous-database-serverless/doc/external-calls-with-customer-managed-wallet.html must be followed.