Jefferson Jungla
Member
When importing the file with clob is returning error ORA-03114
00:00:15.647 TOracleQuery ImportForm.Query Start Query.Execute
SQL = insert into NFE_NOTAFISCAL
(codfil, tpnota, numnota, serie, dtnota, statusnfe, dtenvio, dtautorizacao, codigoretorno, retorno, nprot, dtcancelamento, useridcancelamento, recibo, reimpressa, chaveacesso, xml, id, dpec)
values
v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, empty_clob(), :v17, null)returning xml, dpec into :v16, :v18
:V0 = 198
:V1 = 57
:V2 = 8777
:V3 = 2
:V4 = 08-12-2013 00:00:00
:V5 = 3
:V6 = 10-12-2013 00:00:00
:V7 = 10-12-2013 08:20:17.000000
:V8 = 100
:V9 = Autorizado o uso da NF-e
:V10 = 422130014493264
:V11 = Null
:V12 = Null
:V13 = 224000133679958
:V14 = 0
:V15 = 22131201008073013170550020000087771000087770
:V16S = empty_clob()
:V16 = (CLOB)
:V17 = 4901886
:V18S = null
:V18 = (CLOB)
00:00:15.655 TOracleQuery ImportForm.Query End (1 record processed)
Duration = 0
00:00:15.662 TLOBLocator Start LOB.Write(7786)
00:00:15.983 TLOBLocator End
Result = Access violation at address 00007FFB33C79191 in module 'OraClient19.Dll'. Write of address 0000000000000000
Duration = 0,313
00:00:15.993 TOracleQuery ImportForm.Query Start Query.Execute
SQL = insert into NFE_NOTAFISCAL
(codfil, tpnota, numnota, serie, dtnota, statusnfe, dtenvio, dtautorizacao, codigoretorno, retorno, nprot, dtcancelamento, useridcancelamento, recibo, reimpressa, chaveacesso, xml, id, dpec)
values
v0, :v1, :v2, :v3, :v4, :v5, :v6, :v7, :v8, :v9, :v10, :v11, :v12, :v13, :v14, :v15, empty_clob(), :v17, null)returning xml, dpec into :v16, :v18
:V0 = 30
:V1 = 57
:V2 = 1
:V3 = 2
:V4 = 01-02-2010 00:00:00
:V5 = 3
:V6 = 01-02-2010 00:00:00
:V7 = 01-02-2010 08:50:48.000000
:V8 = 100
:V9 = Autorizado o uso da NF-e
:V10 = 150100003644071
:V11 = Null
:V12 = Null
:V13 = Null
:V14 = 1
:V15 = Null
:V16S = empty_clob()
:V16 = (CLOB)
:V17 = 138908
:V18S = null
:V18 = (CLOB)
00:00:16.000 TOracleQuery ImportForm.Query End
Result = ORA-01013: o usu
