You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 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;
/
Is't possible to see result set from DB send to file ?
I see from log logstash, that call was, but file is empty.
Thanks for any advice or comment
Richard
The text was updated successfully, but these errors were encountered:
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 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"
}
}
Is't possible to see result set from DB send to file ?
I see from log logstash, that call was, but file is empty.
Thanks for any advice or comment
Richard
The text was updated successfully, but these errors were encountered: