Error with set serveroutput on, PL/SQL script fails to execute in FME?

0

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.

Page 1 / 1

I think FME has no idea where to store this value or output the text.

Scripts in the SQLCreator are run to create a feature.

If you want 'TEST LINE' in var1 on a feature, you can use:

Select 'TEST LINE' as "var1" from Dual in the SQLCreator.

I think FME has no idea where to store this value or output the text.

Scripts in the SQLCreator are run to create a feature.

If you want 'TEST LINE' in var1 on a feature, you can use:

Select 'TEST LINE' as "var1" from Dual in the SQLCreator.

Can you please tel me how to do that?

For a new feature use the above query in the SQLCreator and expose var1.

For adding var1 to an existing feature, use the SQLExecutor with the query.

For help on these transformers, follow the link (transformer name).

Sign up