Overview

Namespaces

  • None
  • Yajra
    • Oci8
      • Auth
      • Connectors
      • Eloquent
      • Query
        • Grammars
        • Processors
      • Schema
        • Grammars

Classes

  • Oci8Connection
  • Oci8ServiceProvider

Traits

  • OracleReservedWords
  • Overview
  • Namespace
  • Class

Class Oci8Connection

Illuminate\Database\Connection
Extended by Yajra\Oci8\Oci8Connection
Namespace: Yajra\Oci8
Located at Oci8/Oci8Connection.php
Methods summary
public
# __construct( PDO|Closure $pdo, string $database = '', string $tablePrefix = '', array $config = [] )

Parameters

$pdo
$database
$tablePrefix
$config
public string
# getSchema( )

Get current schema.

Get current schema.

Returns

string
public
# setSchema( string $schema )

Set current schema.

Set current schema.

Parameters

$schema

Returns


$this
public
# setSessionVars( array $sessionVars )

Update oracle session variables.

Update oracle session variables.

Parameters

$sessionVars

Returns


$this
public Yajra\Oci8\Schema\Sequence
# getSequence( )

Get sequence class.

Get sequence class.

Returns

Yajra\Oci8\Schema\Sequence
public Yajra\Oci8\Schema\Sequence
# setSequence( Yajra\Oci8\Schema\Sequence $sequence )

Set sequence class.

Set sequence class.

Parameters

$sequence

Returns

Yajra\Oci8\Schema\Sequence
public Yajra\Oci8\Schema\Trigger
# getTrigger( )

Get oracle trigger class.

Get oracle trigger class.

Returns

Yajra\Oci8\Schema\Trigger
public Yajra\Oci8\Schema\Trigger
# setTrigger( Yajra\Oci8\Schema\Trigger $trigger )

Set oracle trigger class.

Set oracle trigger class.

Parameters

$trigger

Returns

Yajra\Oci8\Schema\Trigger
public Yajra\Oci8\Schema\OracleBuilder
# getSchemaBuilder( )

Get a schema builder instance for the connection.

Get a schema builder instance for the connection.

Returns

Yajra\Oci8\Schema\OracleBuilder
public Yajra\Oci8\Query\OracleBuilder
# table( string $table )

Begin a fluent query against a database table.

Begin a fluent query against a database table.

Parameters

$table

Returns

Yajra\Oci8\Query\OracleBuilder
public
# setDateFormat( string $format = 'YYYY-MM-DD HH24:MI:SS' )

Set oracle session date format.

Set oracle session date format.

Parameters

$format

Returns


$this
public Doctrine\DBAL\Connection
# getDoctrineConnection( )

Get doctrine connection.

Get doctrine connection.

Returns

Doctrine\DBAL\Connection
protected Doctrine\DBAL\Driver\OCI8\Driver
# getDoctrineDriver( )

Get doctrine driver.

Get doctrine driver.

Returns

Doctrine\DBAL\Driver\OCI8\Driver
public mixed
# executeFunction( string $sql, array $bindings = [], integer $returnType = Yajra\Oci8\PDO::PARAM_STR )

Execute a PL/SQL Function and return its value. Usage: DB::executeFunction('function_name(:binding_1,:binding_n)', [':binding_1' => 'hi', ':binding_n' => 'bye'], PDO::PARAM_LOB).

Execute a PL/SQL Function and return its value. Usage: DB::executeFunction('function_name(:binding_1,:binding_n)', [':binding_1' => 'hi', ':binding_n' => 'bye'], PDO::PARAM_LOB).

Parameters

$sql
(mixed)
$bindings
(kvp array)
$returnType
(PDO::PARAM_*)

Returns

mixed
$returnType

Author

Tylerian - jairo.eog@outlook.com
public array
# executeProcedure( string $procedureName, array $bindings, mixed $returnType = Yajra\Oci8\PDO::PARAM_STMT )

Execute a PL/SQL Procedure and return its result. Usage: DB::executeProcedure($procedureName, $bindings). $bindings looks like: $bindings = [ 'p_userid' => $id ];

Execute a PL/SQL Procedure and return its result. Usage: DB::executeProcedure($procedureName, $bindings). $bindings looks like: $bindings = [ 'p_userid' => $id ];

Parameters

$procedureName
$bindings
$returnType

Returns

array
public
# bindValues( PDOStatement $statement, array $bindings )

Bind values to their parameters in the given statement.

Bind values to their parameters in the given statement.

Parameters

$statement
$bindings
protected Illuminate\Database\Grammar|Yajra\Oci8\Query\Grammars\OracleGrammar
# getDefaultQueryGrammar( )

Get the default query grammar instance.

Get the default query grammar instance.

Returns

Illuminate\Database\Grammar|Yajra\Oci8\Query\Grammars\OracleGrammar
public Illuminate\Database\Grammar
# withTablePrefix( Illuminate\Database\Grammar $grammar )

Set the table prefix and return the grammar.

Set the table prefix and return the grammar.

Parameters

$grammar

Returns

Illuminate\Database\Grammar
public Illuminate\Database\Grammar
# withSchemaPrefix( Illuminate\Database\Grammar $grammar )

Set the schema prefix and return the grammar.

Set the schema prefix and return the grammar.

Parameters

$grammar

Returns

Illuminate\Database\Grammar
protected string
# getConfigSchemaPrefix( )

Get config schema prefix.

Get config schema prefix.

Returns

string
protected Illuminate\Database\Grammar|Yajra\Oci8\Schema\Grammars\OracleGrammar
# getDefaultSchemaGrammar( )

Get the default schema grammar instance.

Get the default schema grammar instance.

Returns

Illuminate\Database\Grammar|Yajra\Oci8\Schema\Grammars\OracleGrammar
protected Yajra\Oci8\Query\Processors\OracleProcessor
# getDefaultPostProcessor( )

Get the default post processor instance.

Get the default post processor instance.

Returns

Yajra\Oci8\Query\Processors\OracleProcessor
Properties summary
protected string $schema
#
protected Yajra\Oci8\Schema\Sequence $sequence
#
protected Yajra\Oci8\Schema\Trigger $trigger
#
API documentation generated by ApiGen