Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 16 Apr 2007 @ 16:39:19 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020