Forums | Admin

Discussion Forums: help

Start New Thread

Message: 97150 BY: Raimonds Simanovskis (raymonds) DATE: 2011-11-14 20:31 SUBJECT: RE: read output from anonymous pl/sql block   Why do you need to execute anonymous PL/SQL blocks? If you need to execute PL/SQL stored procedures then I recommend to use ruby-plsql gem (https://github.com/rsim/ruby-plsql). And then you can assign Ruby IO stream to plsql.dbms_output_stream and then all DMBS_OUTPUT will be retrieved and written to this IO stream whenever you will execute PL/SQL procedures. See examples at https://github.com/rsim/ruby-plsql/blob/master/spec/plsql/schema_spec.rb#L209

Thread View

Thread Author Date read output from anonymous pl/sql block Eric Peterson 2011-11-14 16:10       RE: read output from anonymous pl/sql block Raimonds Simanovskis 2011-11-14 20:31             RE: read output from anonymous pl/sql block Eric Peterson 2011-11-14 22:29       RE: read output from anonymous pl/sql block Beethoven Cheng 2012-07-11 18:46