I am returning a variable string from oracle stored plsql function. Function is executed successfully in sql creator without an error. I need to know how/where to see/populate the output returned from stored function.
Userlevel 2
+17
- Contributor
- 7538 replies
-
26 February 2019
If the SQL is a SELECT statement, the records in the result table will be output via the Result port of the SQLCreator as features. You can see the contents of them with the FME Data Inspector if you connect an Inspector to the port and run the workspace.
Userlevel 4
- 8170 replies
-
26 February 2019
As @takashi says, if you want to return data from Oracle it needs to come from a SELECT statement.
There are some ways to force e.g. function return values into a table structure, however. Example:
SELECT *
FROM TABLE(my_schema.my_package.my_function(
param1 => '@Value(fme_attribute1)',
param2 => '@Value(fme_attribute2)'
))This will execute my_function() with the string parameters param1 and param2 based on the FME attributes fme_attribute1 and fme_attribute2. The return value(s) of my_function() will be returned in FME.
You can find more information about this technique in the Oracle docs as well as here:
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.