I'm having a problem with a INSERT
in Oracle using the yajra / laravel-oci8 package, where I get the following error:
Error Code: 1722 Error Message: ORA-01722: invalid number Position : 260 Statement: insert into TRANSMISSAOITBIDIGITAL (INSCRICAOIMOVEL, SELLER, PURCHASER, DATALANCAMENTO, DATATRANSACAO, VLTRANSACAO, VLFINANCIADO, VLNAOFINANCIADO, FINANCIADOSFH, NUGUIAITBI, SITUACAO) values (: autoparam0, autoparam1, autoparam2, autoparam3, : autoparam4,: autoparam5,: autoparam6,: autoparam7, : autoparam9,: autoparam10) (SQL: insert into TRANSMISSAOITBIDIGITAL (INSCRICAOIMOVEL, SELLER, BUYER, DATALANCAMENTO, DATATRANSACAO, VLTRANSACAO, VLFINANCIADO, VLNAOFINANCIADO, FINANCIADOSFH, NUGUIAITBI, SITUACAO) values (3697, 59327952553, 62298852553, 06/20/2014, 20/06/2014, 100000.00, 50000.00, 50000.00, S, 1/2014, 0))
This is the function that does 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. Can anyone help me?