in reply to DBD::Oracle SQL query
why do it in dbi??? It's not portable to other databases anyway...
try something like this...make sure the user running the scripts is a dba... (for connect internal), or use another way.open sqlplus,'|sqlplus'; print <<THERE; system manager connect internal shutdown immediate quit THERE close sqlplus;
|
|---|