-   Although it's in the 9i docco, look at
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/01_oview.htm#6946
  
 -   Oracle8 and Oracle8i are obsolete.  Consider upgrading to at least 9i
to eliminate the minor differences in the functions that can be used in
both places. 
  
 -   You should not be getting different results from the SQL statement. 
SQL is SQL, even when it's called from PL/SQL.
 
/Hans
Received on Thu Apr 28 2005 - 12:14:40 CDT