in reply to Can SQL*PLUS features be set via the DBI module ?

I don't think so. I don't think that DBI interfaces
to SQL*Plus therefore SQL*Plus commands like ...
edit, spool, set pagesize etc ... would just been seen
as bad sql statements.


But if you wanted to exec SQL*Plus commands from perl you
could try something like this ...

open SQLPLUS, "sqlplus whatever/whoknows@somewhere|"; print SQLPLUS << COMMANDS; set pageszie 1000 spool myfile desc myTable select blah from myTable / spool off / COMMANDS


... beware that the above is off the top of my head
and I am not 100% sure that you can cut-n-paste it
and have it run. I hope that some version of te above
snippet can point you in the right direction.