Module: PLSQL::PackageClassMethods

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

Overview

:nodoc:

Instance Method Summary collapse

Instance Method Details

#find(schema, package_name) ⇒ Object 



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

def find(schema, package_name)
  find_package_in_schema(schema, package_name) || find_package_by_synonym(schema, package_name)
end

#find_by_db_object(db_object) ⇒ Object 



7
8
9
 
# File 'lib/plsql/package.rb', line 7

def find_by_db_object(db_object)
  find(db_object.schema, db_object.name)
end

#find_package_by_synonym(schema, package_name) ⇒ Object 



22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/plsql/package.rb', line 22

def find_package_by_synonym(schema, package_name)
  row = schema.select_first("    SELECT o.owner, o.object_name\n    FROM   all_synonyms s,\n           all_objects o\n    WHERE  s.owner IN (:owner, 'PUBLIC')\n    AND    s.synonym_name = :synonym_name\n    AND    o.owner = s.table_owner\n    AND    o.object_name = s.table_name\n    AND    o.object_type = 'PACKAGE'\n    ORDER BY DECODE(s.owner, 'PUBLIC', 1, 0)\n  SQL\n  new(schema, row[1], row[0]) if row\nend\n", schema.schema_name, package_name.to_s.upcase)

#find_package_in_schema(schema, package_name) ⇒ Object 



11
12
13
14
15
16
17
18
19
20
 
# File 'lib/plsql/package.rb', line 11

def find_package_in_schema(schema, package_name)
  row = schema.select_first("    SELECT object_name\n    FROM   all_objects\n    WHERE  owner = :owner\n    AND    object_name = :package\n    AND    object_type = 'PACKAGE'\n  SQL\n  new(schema, package_name) if row\nend\n", schema.schema_name, package_name.to_s.upcase)