MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]

Class: MDB2_Driver_Function_oci8

Source Location: /MDB2_Driver_oci8-1.5.0b4/MDB2/Driver/Function/oci8.php

Class Overview

MDB2_Driver_Function_Common
   |
   --MDB2_Driver_Function_oci8

MDB2 oci8 driver for the function modules


Author(s):

Methods


Inherited Variables

Inherited Methods


Class Details

[line 56]
MDB2 oci8 driver for the function modules


[ Top ]


Method Detail

executeStoredProc   [line 72]

mixed executeStoredProc( string $name, [mixed $params = null], [mixed $types = null], [mixed $result_class = true], [mixed $result_wrap_class = false])

Execute a stored procedure and return any results
  • Return: a result handle or MDB2_OK on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $name     string that identifies the function to execute
mixed   $params     array that contains the paramaters to pass the stored proc
mixed   $types     array that contains the types of the columns in the result set
mixed   $result_class     string which specifies which result class to use
mixed   $result_wrap_class     string which specifies which class to wrap results in

[ Top ]

functionTable   [line 93]

string functionTable( )

return string for internal table used when calling only a function
  • Return: for internal table used when calling only a function
  • Access: public

[ Top ]

guid   [line 180]

string guid( )

Returns global unique identifier
  • Return: to get global unique identifier
  • Access: public

[ Top ]

now   [line 111]

string now( [ $type = 'timestamp'])

Return string to call a variable with the current timestamp inside an SQL statement

There are three special variables for current date and time:

  • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)
  • CURRENT_DATE (date, DATE type)
  • CURRENT_TIME (time, TIME type)

  • Return: to call a variable with the current timestamp
  • Access: public

Parameters:

   $type     

[ Top ]

random   [line 166]

return random( )

return string to call a function to get random value inside an SQL statement
  • Return: string to generate float between 0 and 1
  • Access: public

[ Top ]

substring   [line 149]

string substring( $value, [ $position = 1], [ $length = null])

return string to call a function to get a substring inside an SQL statement
  • Return: to call a function to get a substring
  • Access: public

Parameters:

   $value     
   $position     
   $length     

[ Top ]

unixtimestamp   [line 133]

string unixtimestamp( string $expression)

return string to call a function to get the unix timestamp from a iso timestamp
  • Return: to call a variable with the timestamp
  • Access: public

Parameters:

string   $expression     

[ Top ]


Documentation generated on Tue, 23 Oct 2012 18:30:49 +0000 by phpDocumentor 1.4.3. PEAR Logo Copyright © PHP Group 2004.