CreateCommand a sql contain a colon

Yii 2.0 General Discussions
1

I have oracle sql to create trigger




Yii::$app->db->createCommand(<<<SQL

    CREATE OR REPLACE TRIGGER {{%user_profile_field_bir}}

    BEFORE INSERT ON {{%user_profile_field}} 

    FOR EACH ROW

    BEGIN

        SELECT {{%user_profile_field_seq}}.NEXTVAL INTO :new."id" FROM   dual;

    END;

SQL

        )

the :new above is not a params, is a identifier in oracle language, how I can skip the PDO prepare proccess?

2

not recommend, but this is the only solution




$command = $this->db->createCommand(<<<SQL

    CREATE OR REPLACE TRIGGER {{%user_profile_field_bir}}

    BEFORE INSERT ON {{%user_profile_field}}

    FOR EACH ROW

    BEGIN

        SELECT {{%user_profile_field_seq}}.NEXTVAL INTO :new."id" FROM   dual;

    END;

SQL

)->getRawSql();

$this->db->pdo->exec($command);

http://stackoverflow.com/questions/17811936/php-pdo-is-there-a-way-to-disable-named-placeholders-oracle-autoincrement-issu