class DbMeta::Oracle::Procedure

Attributes

source[R]

Public Instance Methods

extract(args = {}) click to toggle source
# File lib/db_meta/oracle/types/procedure.rb, line 20
def extract(args = {})
  buffer = [block(@name)]
  buffer << "create or replace #{@source.strip}"
  buffer << "/"
  buffer << nil
  buffer.join("\n")
end
fetch() click to toggle source
# File lib/db_meta/oracle/types/procedure.rb, line 8
def fetch
  @source = ""
  connection = Connection.instance.get
  cursor = connection.exec("select text from user_source where type = 'PROCEDURE' and name = '#{@name}' order by line")
  while (row = cursor.fetch)
    @source << row[0].to_s
  end
  cursor.close
ensure
  connection.logoff
end