If you are wanting to capture the output of a system run command, you don't want to use the system() function as all it returns is the exit status of what it ran. Instead, just use backtics as follows:
-
$C = `sqlplus $DBUSER/$DBPW \@getcolnam.sql $TABNAM $TABOWNER`;
-
Regards,
Jeff