Can I call an SP, run a bteq or shellscript from inside a UDF?
I'm currently working at a migration project from Oracle to TD, and they have some operational reports that are called from the Publisher of OBIEE through Oracle Function Tables, something like this:
- The user log from Web application and executes the report
- The SQL executed is like : Select * from Function_Table(Parameters).
Inside the function_table code, there is: SQL code of the report, the export of the result set to a flat file, the compression of the file, and a email to the user saying that the report is done and the location of the file.
So, I was thinking in doing in TD something like: Select UDF(Parameters)
Where the UDF call a bteq or shellscript that does all the same as the Oracle Function Table.
In c,c++, you need to have your specific header files and check them before implementing like example: