Class: OCI8::Metadata::ProcBase

Inherits:
Base show all
Defined in:
lib/oci8/metadata.rb

Overview

Abstract super class of Procedure and Function.

– How can I know whether FUNCTION or PROCEDURE? ++

Direct Known Subclasses

Function, Procedure

Instance Method Summary collapse

Methods inherited from Base

#obj_id, #obj_name, #obj_schema, #timestamp

Instance Method Details

#argumentsObject

array of Argument objects.

The first element is the return type in case of Function.



699
700
701
# File 'lib/oci8/metadata.rb', line 699

def arguments
  @arguments ||= list_arguments.to_a
end

#inspectObject

:nodoc:



703
704
705
# File 'lib/oci8/metadata.rb', line 703

def inspect # :nodoc:
  "#<#{self.class.name}: #{name}>"
end

#is_invoker_rights?Boolean

indicates the procedure or function has invoker’s rights

Returns:

  • (Boolean)


673
674
675
# File 'lib/oci8/metadata.rb', line 673

def is_invoker_rights?
  __boolean(OCI_ATTR_IS_INVOKER_RIGHTS)
end

#nameObject

name of the procedure or function.

available only for a Package subprogram.



682
683
684
# File 'lib/oci8/metadata.rb', line 682

def name
  __text(OCI_ATTR_NAME)
end

#overload_idObject

overloading ID number (relevant in case the procedure or function is part of a package and is overloaded). Values returned may be different from direct query of a PL/SQL function or procedure. (What this means?)

available only for a Package subprogram.



692
693
694
# File 'lib/oci8/metadata.rb', line 692

def overload_id
  __ub2(OCI_ATTR_OVERLOAD_ID)
end