http://qs1969.pair.com?node_id=11141889

clueless newbie has asked for the wisdom of the Perl Monks concerning the following question:

I'm dealing with an Oracle database via DBI and DBD::Oracle and have several questions: WARNING: TOTAL Oracle newbie!

1) Exactly What does the statement to be prepared look like when one need "dbms_metadata.set_transform_param(dbms_metadata.session_transform,'storage',false)" prior to ones "select to_char(dbms_metadata.get_ddl(object_type, object_name, owner))"?

$STH=$DBH->prepare('_SQL_'); dbms_metadata.set_transform_param(dbms_metadata.session_transform,' +storage',false); SELECT to_char(dbms_metadata.get_ddl(object_type, object_name, owne +r)) ... _SQL_

yields "DBD::Oracle::st execute failed: ORA-01036: illegal variable name/number (DBD ERROR: OCIBindByName)...

2) From the DBI how does one "fetch" DBMS_OUTPUT's buffer?

Thanks!