[PR #1062] Doctrine new config parameter on oracle dbal/mapping: Owner #9106

New Issue

admin · 2026-01-22T16:03:13+01:00

admin commented

2026-01-22 16:03:13 +01:00

Original Pull Request: https://github.com/doctrine/orm/pull/1062

State: closed
Merged: No

When i can access a database with a user and map other user schema, example:

I connect to the server using USER1 credentials and need to use USER2 schema

Ccctually this is not suported:

Sugestions:

set a new config parameter with owner to put on front query like select * from OWNER.TABLE

and on the mapping update query mappings with these:

swap this:

doctrine\dbal\lib\Doctrine\DBAL\Platforms\OraclePlatform.php
public function getListSequencesSQL($database)
  322      {
  323:         return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
  324                 "WHERE SEQUENCE_OWNER = '".strtoupper($database)."'";
  325      }
  ...
  387      public function getListViewsSQL($database)
  388      {
  389:         return 'SELECT view_name, text FROM sys.user_views';
  390      }

FOR THIS

public function getListSequencesSQL($database,$owner)
{
    return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
           "WHERE SEQUENCE_OWNER = '".$owner."'";
}


/**
 * {@inheritDoc}
 */
public function getListSequencesSQL($database,$owner)
{
    return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ".
           "WHERE SEQUENCE_OWNER = '".$owner."'";
}

Worked fine for me on tests.

Tnks

**Original Pull Request:** https://github.com/doctrine/orm/pull/1062 **State:** closed **Merged:** No --- When i can access a database with a user and map other user schema, example: I connect to the server using USER1 credentials and need to use USER2 schema Ccctually this is not suported: Sugestions: set a new config parameter with owner to put on front query like select \* from OWNER.TABLE and on the mapping update query mappings with these: swap this: ``` doctrine\dbal\lib\Doctrine\DBAL\Platforms\OraclePlatform.php public function getListSequencesSQL($database) 322 { 323: return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ". 324 "WHERE SEQUENCE_OWNER = '".strtoupper($database)."'"; 325 } ... 387 public function getListViewsSQL($database) 388 { 389: return 'SELECT view_name, text FROM sys.user_views'; 390 } ``` FOR THIS ``` public function getListSequencesSQL($database,$owner) { return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ". "WHERE SEQUENCE_OWNER = '".$owner."'"; } /** * {@inheritDoc} */ public function getListSequencesSQL($database,$owner) { return "SELECT sequence_name, min_value, increment_by FROM sys.all_sequences ". "WHERE SEQUENCE_OWNER = '".$owner."'"; } ``` Worked fine for me on tests. Tnks

admin added the pull-request label 2026-01-22 16:03:13 +01:00

admin closed this issue

2026-01-22 16:03:13 +01:00

admin referenced this issue

2026-01-22 16:10:35 +01:00

[PR #9106] `Query::getResult` and `Query::toIterable` results differ when selecting multiple entities. #11375

Sign in to join this conversation.