Hello,
I created some procedure in oracle database aum which return sys_refcursor.
create or replace procedure aum
IS
v_code NUMBER;
v_errm VARCHAR2(200);
rc sys_refcursor;
BEGIN
open rc for select username from f=dba_users;
dbms_sql.return_result(rc);
EXCEPTION
WHEN OTHERS THEN
v_code := SQLCODE;
v_errm := SUBSTR(SQLERRM, 1, 200);
DBMS_OUTPUT.PUT_LINE (v_code || ' ' || v_errm);
END;
/
My configuration in logstash is
input {
jdbc {
jdbc_validate_connection => true
jdbc_driver_library => "/etc/logstash/ojdbc8.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
jdbc_connection_string => "jdbc:oracle:thin:@//xxxxxcom:1521/xxx"
jdbc_user => "system"
jdbc_password => "xxxxx"
statement => "{call system.aum}"
schedule => "*/3 * * * *"
}
}
output {
file {
path => "/tmp/my_out_file3.txt"
codec => "rubydebug"
}
}
Problem is, that output data from procedure doesn't inside in file. I see in log , that logstash call the procedure ok, but there is some problem with output ?
Any idea ?
Thanks
Richard