 |
Forums |
Admin Discussion Forums: help Start New Thread
| Message: 97151 |
|
BY: Eric Peterson (ericdp)
DATE: 2011-11-14 22:29
SUBJECT: RE: read output from anonymous pl/sql block much of my work is done in quick anonymous blocks. Not going to be saved as a procedure or in a package. A quick output to DBMS_OUTPUT to show a status, etc.
Here is what I get with this package. Even more errors.
> cat db2.rb
#!/usr/bin/env ruby19 -KU -w
# encoding: UTF-8
require 'oci8'
require 'ruby-plsql'
plsql.connection = OCI8.new( 'uuu', 'ppp', hhh' )
plsql.dbms_output_stream = STDOUT
plsql.execute <<-SQL
DECLARE
l_now VARCHAR2(20 CHAR) := TO_CHAR( SYSDATE, 'DD Mon YYYY HH24:MI:SS' );
BEGIN
DBMS_OUTPUT.put_line( 'This is a test. ' || l_now );
DBMS_OUTPUT.put_line( 'This is a another test. ' || l_now );
END;
SQL
puts '***> Before'
puts plsql.dbms_output_stream.string
puts '***> After'
plsql.logoff
exit 0
> ./db2.rb
/usr/local/lib/ruby/site_ruby/1.9.1/oci8/object.rb:374: warning: assigned but unused variable - args
/usr/local/lib/ruby/gems/1.9.1/gems/ruby-plsql-0.4.4/lib/plsql/variable.rb:86: warning: shadowing outer local variable - column
/usr/local/lib/ruby/gems/1.9.1/gems/ruby-plsql-0.4.4/lib/plsql/table.rb:61: warning: assigned but unused variable - data_type_mod
/usr/local/lib/ruby/gems/1.9.1/gems/ruby-plsql-0.4.4/lib/plsql/type.rb:70: warning: assigned but unused variable - data_type_mod
/usr/local/lib/ruby/gems/1.9.1/gems/ruby-plsql-0.4.4/lib/plsql/oci_connection.rb:210: warning: assigned but unused variable - attr_length
/usr/local/lib/ruby/gems/1.9.1/gems/ruby-plsql-0.4.4/lib/plsql/oci_connection.rb:229: warning: assigned but unused variable - attr_length
***> Before
./db2.rb:20:in `<main>': undefined method `string' for #<IO:<STDOUT>> (NoMethodError) | |
Thread View
Post a followup to this message
|
|
read output from anonymous pl/sql block