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?
These date fields are of what type?
– Daniel Lemes
One strange thing is that the type DATE or CHAR fields should be in parentheses , as the interface treats this !?
– Motta