Skip to content

ORA-12533: TNS:illegal ADDRESS parameters #77

Open
@digitlimit

Description

@digitlimit

Summary of problem or feature request

I am running Laravel 6
I'm getting the error below:

ORA-12533: TNS:illegal ADDRESS parameters

My .env
DB_CONNECTION=oracle
DB_HOST=127.0.0.1
DB_POST=1521
DB_DATABASE=XE
DB_USERNAME=HR
DB_PASSWORD=hshahashs

My controller:

namespace App\Http\Controllers;

use App\Models\Employee;

class HomeController extends Controller
{
    public function index(){

        $employees = Employee::all();
        dd($employees);
    }
}

Models

<?php
namespace App\Models;

use Yajra\Oci8\Eloquent\OracleEloquent as Eloquent;

class Employee extends Eloquent {

    protected $connection = 'oracle';

    protected $table = 'employees';

    // define binary/blob fields
//    protected $binaries = ['content'];

    // define the sequence name used for incrementing
    // default value would be {table}_{primaryKey}_seq if not set
//    protected $sequence = null;

}

I tried this directly and it works without the package

       $conn = oci_connect("HR", "hshahashs", "localhost/XE");
        $stdi = oci_parse($conn, "SELECT * FROM employees");

        if(oci_execute($stdi)){
            dd(oci_fetch_assoc($stdi));
        }

Please assist

  • Operating System - windows (Wamp)
  • PHP Version -PHP 7.3
  • PDO-VIA-OCI8 Version

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions