OracleDB Interval type not recognized by the ORM during schema import #5525

New Issue

admin · 2026-01-22T15:10:02+01:00

admin commented

2026-01-22 15:10:02 +01:00

Originally created by @licarigianluca on GitHub (May 8, 2017).

Originally assigned to: @Ocramius on GitHub.

When I run this command
php bin/console doctrine:schema:validate

the system print this message

Unknown database type interval day(3) to second(6) requested, Doctrine\DBAL
\Platforms\OraclePlatform may not support it.

I have an Oracle database schema that i cannot change. I need to import some tables into entities but the command fails and print the message above. There is a way to ignore that check? I used the filter argument but the check fails everytime.

Thanks

Originally created by @licarigianluca on GitHub (May 8, 2017). Originally assigned to: @Ocramius on GitHub. When I run this command php bin/console doctrine:schema:validate the system print this message Unknown database type interval day(3) to second(6) requested, Doctrine\DBAL \Platforms\OraclePlatform may not support it. I have an Oracle database schema that i cannot change. I need to import some tables into entities but the command fails and print the message above. There is a way to ignore that check? I used the filter argument but the check fails everytime. Thanks

admin added the Question label 2026-01-22 15:10:02 +01:00

admin closed this issue

2026-01-22 15:10:04 +01:00

admin commented

2026-01-22 15:10:04 +01:00

@Ocramius commented on GitHub (May 8, 2017):

There is a way to ignore that check?

You can map the type as a DBAL type manually. See http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/custom-mapping-types.html

You want to do $platform->registerDoctrineTypeMapping(...)

@Ocramius commented on GitHub (May 8, 2017): > There is a way to ignore that check? You can map the type as a DBAL type manually. See http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/custom-mapping-types.html You want to do `$platform->registerDoctrineTypeMapping(...)`

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5525