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("    SELECT o.object_name, o.owner\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[0], row[1]) if row\nend\n", schema.schema_name, package_name)

#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("    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)