Problems with Oracle Insert with Laravel

Asked

Viewed 253 times

1

I’m having a problem with a INSERT in Oracle used the package yajra/Aravel-oci8, where the following error returns to me:

Error Code : 1722 Error Message : ORA-01722: Invalid Number Position : 260 Statement : Insert into TRANSMISSAOITBIDIGITAL (INSCRICAOIMOVEL, SELLER, BUYER, DATE, DATE TRANSACTION, VLTRANSACTION, VLFINANCIADO, VLNAOFINANCIADO, FINANCIADOSFH, NUGUIAITBI, SITUACAO) values (autoparam0, :autoparam1, :autoparam2, :autoparam3, for:autoparam4, for:autoparam5, for:autoparam6, for:autoparam7, for:autoparam8, :autoparam9, :autoparam10) (SQL: Insert into TRANSMISSAOITBIDIGITAL (INSCRICAOIMOVEL, SELLER, BUYER, DATING, TRANSACTION DATE, VLTRANSACAO, VLFINANCIADO, VLNAOFINANCIADO, FINANCIADOSFH, NUGUIAITBI, SITUATION) values (3697, 59327952553, 62298852553, 20/06/2014, 20/06/2014, 100000.00, 50000.00, 50000.00, S, 1/2014, 0))

this and the function that makes the INSERT

    public static function inserir(\entidades\Transmissao $transmissao){
        DB::setDateFormat('DD/MM/YYYY');
        DB::table('TRANSMISSAOITBIDIGITAL')->insert(array(
            'INSCRICAOIMOVEL' => $transmissao->getInscricaoimovel(),
            'VENDEDOR' => $transmissao->getVendedor(),
            'COMPRADOR' => $transmissao->getComprador(),
            'DATALANCAMENTO' => $transmissao->getDataLancamento(),
            'DATATRANSACAO' => $transmissao->getDataTrasacao(),
            'VLTRANSACAO' => $transmissao->getVlTransacao(),
            'VLFINANCIADO' => $transmissao->getVlFinanciado(),
            'VLNAOFINANCIADO' => $transmissao->getVlNaoFinanciado(),
            'FINANCIADOSFH' => $transmissao->getFinanciadosfh(),
            'NUGUIAITBI' => $transmissao->getNuGuiaItbi(),
            'SITUACAO' => $transmissao->getSituacao()
        ));
    }

I have no idea where Position 260 is to find the error. Someone can help me?

  • 1

    These date fields are of what type?

  • 2

    One strange thing is that the type DATE or CHAR fields should be in parentheses , as the interface treats this !?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.