Module: PLSQL::PackageClassMethods

Included in:
Package
Defined in:
lib/plsql/package.rb

Overview

:nodoc:

Instance Method Summary collapse

Instance Method Details

#find(schema, package) ⇒ Object 



3
4
5
6
 
# File 'lib/plsql/package.rb', line 3

def find(schema, package)
  package_name = package.to_s.upcase
  find_in_schema(schema, package_name) || find_by_synonym(schema, package_name)
end

#find_by_synonym(schema, package_name) ⇒ Object 



19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
# File 'lib/plsql/package.rb', line 19

def find_by_synonym(schema, package_name)
  row = schema.select_first(<<-SQL, schema.schema_name, package_name)
    SELECT o.object_name, o.owner
    FROM   all_synonyms s,
           all_objects o
    WHERE  s.owner IN (:owner, 'PUBLIC')
    AND    s.synonym_name = :synonym_name
    AND    o.owner = s.table_owner
    AND    o.object_name = s.table_name
    AND    o.object_type = 'PACKAGE'
    ORDER BY DECODE(s.owner, 'PUBLIC', 1, 0)
  SQL
  new(schema, row[0], row[1]) if row
end

#find_in_schema(schema, package_name) ⇒ Object 



8
9
10
11
12
13
14
15
16
17
 
# File 'lib/plsql/package.rb', line 8

def find_in_schema(schema, package_name)
  row = schema.select_first(<<-SQL, schema.schema_name, package_name)
    SELECT object_name
    FROM   all_objects
    WHERE  owner = :owner
    AND    object_name = :package
    AND    object_type = 'PACKAGE'
  SQL
  new(schema, package_name) if row
end