Is there any way from PL/SQL to call synchronous and asynchronous to send the message to Kafka-CodePudding

I'm trying to research the way to apply Kafka in the legacy system which has an oracle form was written in PL/SQL function. Can we have a mechanism to communicate with PL/SQL with Kafka and return the response object type in the database.(currently we are using AQ(Oracle AQ) in the system, but now I have to change to Kafka)

Example :

DECLARE
  response package.Object;
BEGIN
    response := package.callKafka('parameter');
   DBMS_OUTPUT.PUT_LINE('output: '||response.output);
END;

CodePudding user response：

So interesting to me. Not sure if we can directly send messages from PL/SQL to kafka or that will be a flawed in design.

CodePudding user response：

Create a service that will populate a staging table in your database and use JDBC Source Connector to deliver those data to Kafka. Check this out. enter link description here