Archives of the TeradataForum
Message Posted: Mon, 16 Apr 2007 @ 16:39:19 GMT
| Subj: || || Re: TF to access external data |
| From: || || Geoffrey Rommel |
| ||So, to use a TF to access Oracle I expected to call sqlplus from the TF.|| |
I haven't written any table functions, but I believe this is unnecessary. Instead, your function should probably use a standard interface to
Oracle, most likely ODBC or an Oracle CLI (or JDBC -- can a TF be written in Java?). This would have the added advantage of returning the data in
relatively standard data formats (int, float, etc.) rather than as text that has to be chopped up into columns.