Error Phalcon DevTools Models Oracle

[verde3ro]

I have the following problem when generating the models of an Oracle database.

phalcon create-all-models --mapcolumn --doc --force --schema=MGR_ARVYC

Phalcon DevTools (3.4.0)

ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared (ext\pdo_oci\oci_statement.c:159)

I hope you can help me.

[Jeckerson]

@verde3ro Can you provide example models when it occurs?

[verde3ro]

@Jeckerson, Occurs when generating models with Phalcon DevTools or Web Tools.

[Jeckerson]

@verde3ro Please execute model generation per single table and provide output of SHOW CREATE TABLE of tables where it occurs.

[verde3ro]

@Jeckerson, Execution generation of model per single table:

Table:

CREATE TABLE "AV_USUARIO_C" 
   (	"ID" NUMBER DEFAULT NULL NOT NULL ENABLE, 
	"USUARIO" VARCHAR2(20 BYTE) DEFAULT '' NOT NULL ENABLE, 
	"PASSWORD" VARCHAR2(50 BYTE) DEFAULT '', 
	"NOMBRE" VARCHAR2(250 BYTE) DEFAULT '' NOT NULL ENABLE, 
	"CORREO" VARCHAR2(100 BYTE) DEFAULT '', 
	"ESTATUS" VARCHAR2(5 BYTE) DEFAULT 'AC' NOT NULL ENABLE, 
	"USUARIO_I" VARCHAR2(20 BYTE) DEFAULT '' NOT NULL ENABLE, 
	"FECHA_I" DATE DEFAULT SYSDATE NOT NULL ENABLE, 
	"USUARIO_U" VARCHAR2(20 BYTE), 
	"FECHA_U" DATE, 
	"CORRECTO" NUMBER(1,0) DEFAULT 0, 
	"USUARIO_EBS" VARCHAR2(20 BYTE) DEFAULT '', 
	 CONSTRAINT "AV_USUARIO_PK" PRIMARY KEY ("ID"), 
	 CONSTRAINT "AV_USUARIO_UX" UNIQUE ("USUARIO")
   ) ;

Configuration:

 'database' => [
        'adapter'     => 'Oracle',
        'host'        => '127.0.0.1:1521/XE',
        'username'    => 'MGR_ARVYC',
        'password'    => 'password01',
        'dbname'      => '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA=(SID=XE)))',
        'charset'     => 'utf8',
    ],

Execution:

[Jeckerson]

Option config hasn't been defined is related to another task. That means that your table name will be generated after #1292 will be merged.

Try to find another table that generate this error:
ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared (ext\pdo_oci\oci_statement.c:159)

[verde3ro]

I did not understand the comment:

Option config hasn't been defined is related to another task. That means that your table name will be generated after #1292 will be merged.

Any table in the schema generate the error when created the model.

ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared
 (ext\pdo_oci\oci_statement.c:159)

[Jeckerson]

I did not understand the comment:

You posted screenshot where error is different
https://user-images.githubusercontent.com/13452905/54629138-8c121800-4a3c-11e9-87fd-f0ea4daa64d0.png

[Jeckerson]

So your issue is actual.

[verde3ro]

yes it's actual

[verde3ro]

ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared
 (ext\pdo_oci\oci_statement.c:159)

[Jeckerson]

Can be fixed only when Incubator DB Component is ready for Phalcon v4.

https://github.com/phalcon/incubator-db

[flyingangel]

Error Option namespace hasn't been defined when generating a class with constraint relation.

There's 2 typos in the file Model.php

if ($this->modelOptions->hasOption('namespace')) instead of if ($this->modelOptions->getOption('namespace'))

Devtool tag 4.0.5

[Jeckerson]

@flyingangel I think your issue isn't related to this one. Please create separate one.