Call to undefined function yajra\Pdo\oci_connect() about laravel-oci8 HOT 18 CLOSED

The error indicates that you don't have OCI8 extension enabled or is not functioning well. Can you please check your PHP installation? If possible, use at least PHP 5.3.14 or latest.

from laravel-oci8.

I wasn't aware I had to download OCI8 separately from my PHP installation. (Update README for noobs like me?)

Thank you.

from laravel-oci8.

read me updated. thanks for feedback.

from laravel-oci8.

i have a problem ,
i dont know that the problem where is.

FatalThrowableError in Oci8.php line 455:
Call to undefined function Yajra\Pdo\oci_connect()

this is additional information:

in Oci8.php line 455
at Oci8->connect('(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.10)(PORT = 1521)) (CONNECT_DATA =(SERVICE_NAME = mipg)))', 'haft', 'haft', array(2, 2, 0, 'charset' => 'AL32UTF8'), 'AL32UTF8') in Oci8.php line 78

from laravel-oci8.

@ali2535 it looks like your oci8 extension is still not loaded.
please check php -m | grep oci8 this should show oci8 did you install oci8? it must be activated in php.ini for cli and! apache/nginx

from laravel-oci8.

@mstaack 👍
thanks for your answer my friend . what is grep in windows?
i install wampserver 3 and php7 . and remove ; symbol from first of oci8_12c
why you say not loading?

from laravel-oci8.

when i run this command no return anything. this is ok??

from laravel-oci8.

Where is problem in this connection string ?

at Oci8->connect('(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.10)(PORT = 1521)) (CONNECT_DATA =(SERVICE_NAME = haft)))', 'HAFT', 'HAFT', array(2, 2, 0, 'charset' => ''), '') in Oci8.php line 78

from laravel-oci8.

@ali2535 grep is a bash command so I think it will not work on windows. Just make sure that the proper oci8*.dll extension is enabled on your php.ini.

from laravel-oci8.

@yajra:
yajra it solved . connect to database .
i have question about eloquent models. can i use oracle eloquent similar to mysql eloquent??
there is no good documentation about oracle eloquent. can say me a description and example from this?

thank you so much about this package . good luck

from laravel-oci8.

@ali2535 sure thing.. have a look here: https://yajrabox.com/docs/laravel-oci8/master/oracle-eloquent

from laravel-oci8.

@mstaack : Thank you so much

a question : protected $binaries = ['content'] IS protected $fillable = ['content'] ???????

from laravel-oci8.

@ali2535 you are only required to use OracleEloquent in cases where you have a blob|binary fields. If not, you can use the regular Eloquent/Model and should work like how MySQL does it.

$binaries is not $fillable. Binaries should be set to help us identify which columns are blob|binary.

from laravel-oci8.

Hi, How do we use service name instead of SID to connect to oracle database hosted on other server. Thanks.

from laravel-oci8.

@sonu1 use something like this in your config

            'driver'        => 'oracle',
            'tns'           => env('DATABASE_TNSNAME', 'oracle'),
            'service_name'  => env('DB_SERVICE_NAME', 'service-name'),
            'host'          => env('DB_HOST', '8.8.8.8'),
            'port'          => env('DB_PORT', '1521'),
            'username'      => env('DATABASE_USER', ''),
            'password'      => env('DATABASE_PASSWORD', ''),
            'database'      => env('DB_DATABASE', ''),
            'charset'       => env('DB_CHARSET', 'AL32UTF8'),
            'prefix'        => env('DB_PREFIX', ''),
            'prefix_schema' => env('DB_SCHEMA_PREFIX', ''),
            'options'       => [
                PDO::ATTR_PERSISTENT => true
            ],

from laravel-oci8.

FatalThrowableError in Oci8.php line 455:
Call to undefined function Yajra\Pdo\oci_connect()

from laravel-oci8.

help me

from laravel-oci8.

@lytab look here #360

from laravel-oci8.