1

I am running a script in FME SQL Creator reader. Script looks like,

set serveroutput on
declare var1 a;
BEGIN dbms_output.enable(); dbms_output.put_line ('TEST LINE'); END;

Script runs successfully in Oracle SQL Developer. But If I run from FME, it returns nothing.

APC
  • 144,005
  • 19
  • 170
  • 281
Gauri
  • 169
  • 2
  • 10
  • 1
    Probably FME lacks support for `dbms_output`. This seems like the sort of question you should be asking [on their community forum](https://knowledge.safe.com/questions/index.html) – APC Feb 21 '19 at 22:00
  • 1
    Thank for providing this link fro FME forum. – Gauri Feb 22 '19 at 13:43

1 Answers1

1

Set serveroutput on and dbms_output.enable are oracle sql developer commands and not FME compatible or any other sql executor. So to return results from oracle database use functions on server side and call them from FME.

Gauri
  • 169
  • 2
  • 10