I whish I had time to RTFMFM. ;) All the manuals and tutorials work with small array examples and don't seem to teach much about moving data across scalar, arrays, or hashes...or, perhaps I'm reading the wrong books.

The original sql+ query had a select statement that didn't work through the DBI interface. I think the DBI only uses standard SQL?

SQL statement
 SET HEADING OFF
 SPOOL file.txt
 SELECT 'NUMBER|FIRST|LAST|ID' FROM DUAL;
 SELECT EMPLID ||'|'|| FIRST_NAME || '|' || LAST_NAME || '|' || ID FRO
+M db.VIEW WHERE (length(AS_UNIV_ID)>1) and (length(EMPLID)=9) and (le
+ngth(FIRST_NAME)>1) and (length(LAST_NAME)>1);
 SPOOL OFF
[download]

Best advise...kis. thx N