ORA-01745: Ungültiger Host-/Bindevariablenname caused by :table

[lkainers]

In /src/Metadata/Source/OracleMetadata.php#L127 :table is a reserved word and therefore the query fails

[lkainers]

The query does also contain additional line breaks (#125, #128) and a semicolon at the end (#129)

[Ocramius]

Linking sources: https://github.com/zendframework/zend-db/blob/790123893c01ad597b28652b2a382ac86186c6c8/src/Metadata/Source/OracleMetadata.php

[Ocramius]

@lkainers what oracle version are you testing against? Also, got an example of a generated query?

[lkainers]

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

There is no generated query

zend-db/src/Metadata/Source/OracleMetadata.php

Line 107 in 7901238

$sql = '

is the query

[lkainers]

$params = array(
'driver' => 'Oci8',
'hostname' => 'host',
'username' => 'user',
'password' => pass',
'port' => '',
);

$connection = new Zend\Db\Adapter\Driver\Oci8\Connection($params);
$driver = new Zend\Db\Adapter\Driver\Oci8\Oci8($connection);
$adapter = new Zend\Db\Adapter\Adapter($driver);

$metadata = new Zend\Db\Metadata\Metadata($adapter);
$metadata->getConstraints('tablename');

[vixriihi]

Here's a PR #34 that would fix this issue

[michalbundyra]

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#142.