Re: [cx-oracle-users] Error Expecting numeric Data

[Ivanelson N. <iva...@gm...>]

Solved! The problem was in the type numeric fields. In numeric with
'data_scale', I converted to decimal and without 'scale', I converted to
integer. I also did the same in numeric fields null.

https://github.com/ivanelson/zim2ora/blob/master/zim2ora_bulk.py

[]s

Ivan Nunes
[image: Twitter] <http://ivanelson>
 Get a signature like this.
<http://r1.wisestamp.com/r/landing?promo=18&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18>
Click
here.<http://r1.wisestamp.com/r/landing?promo=18&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18>



2013/1/26 Anthony Tuininga <ant...@gm...>

> executemany() expects all of the data to be in the same format since it is
> sent to the database in one package.
> execute() is being nice to you and simply taking the effort to setup new
> buffers when the data changes -- so it is slower but behaves as you expect.
>
> Find the data type change and your executemany() will function as expected.
>
> Anthony
>
> On Sat, Jan 26, 2013 at 8:04 PM, Ivanelson Nunes <iva...@gm...
> > wrote:
>
>> One. Test: I sent the entire file of 30 to 30 lines and raised no
>> exception.
>> 2nd. Test: I changed the method "executetomany" by "execute" and recorded
>> all 2000 lines without error.
>>
>> ?!
>>
>> 2013/1/26 Anthony Tuininga <ant...@gm...>
>>
>>> On Sat, Jan 26, 2013 at 7:37 PM, Ivanelson Nunes <
>>> iva...@gm...> wrote:
>>>
>>>> Some type of limitation or restriction security. For when I insert only
>>>> 30 lines generates no exception.
>>>>
>>>
>>> No. This a programming error. You are passing *both* strings *and*
>>> numbers at the same time. Oracle insists that it be one type or the other!
>>> The first 30 lines are all of the same type, it would seem. The error
>>> occurs sometime later. One suggestion: print the types of the tuples you
>>> are inserting -- that should help you figure things out.
>>>
>>>
>>>>
>>>> My code is here:
>>>> https://github.com/ivanelson/zim2ora/blob/master/zim2ora_bulk.py
>>>>
>>>> I also found these comments on this issue:
>>>> https://github.com/dmwm/WMCore/issues/4297#issuecomment-10706585
>>>>
>>>>
>>>> Any idea?
>>>>
>>>>
>>>> []s
>>>> 2013/1/26 Roger Downing <rog...@gm...>
>>>>
>>>>> Hi,
>>>>> It would be helpful if you were to give more context to your code.
>>>>> What is 'L' for example?
>>>>>
>>>>> cursor.executemany() expects as its second argument a sequence. The
>>>>> elements of the sequence should either be sequences or parameter mappings
>>>>> as described in the documentation.
>>>>>
>>>>> The error you are getting could mean that you are trying to insert
>>>>> non-numeric data into a column which has been specified as numeric.
>>>>>
>>>>> Cheers,
>>>>>
>>>>> Roger
>>>>>
>>>>>
>>>>> On 25 January 2013 18:19, Ivanelson Nunes <iva...@gm...>wrote:
>>>>>
>>>>>> What kind of error is this?
>>>>>>
>>>>>> cursor.executemany (sql_insert, L)
>>>>>>> TypeError: expecting numeric data
>>>>>>
>>>>>>
>>>>>> I am reading a csv file with 2000 lines and 115 columns.
>>>>>>
>>>>>> Any idea?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Ivan  - Brazil
>>>>>> @ivanelson
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
>>>>>> 2012, HTML5, CSS,
>>>>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills
>>>>>> current
>>>>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>>>>>> MVPs and experts. ON SALE this month only -- learn more at:
>>>>>> http://p.sf.net/sfu/learnnow-d2d
>>>>>> _______________________________________________
>>>>>> cx-oracle-users mailing list
>>>>>> cx-...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
>>>>> 2012, HTML5, CSS,
>>>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>>>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>>>>> MVPs and experts. ON SALE this month only -- learn more at:
>>>>> http://p.sf.net/sfu/learnnow-d2d
>>>>> _______________________________________________
>>>>> cx-oracle-users mailing list
>>>>> cx-...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
>>>> 2012, HTML5, CSS,
>>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>>>> MVPs and experts. ON SALE this month only -- learn more at:
>>>> http://p.sf.net/sfu/learnnow-d2d
>>>> _______________________________________________
>>>> cx-oracle-users mailing list
>>>> cx-...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
>>> 2012, HTML5, CSS,
>>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>>> MVPs and experts. ON SALE this month only -- learn more at:
>>> http://p.sf.net/sfu/learnnow-d2d
>>> _______________________________________________
>>> cx-oracle-users mailing list
>>> cx-...@li...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
>> 2012, HTML5, CSS,
>> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
>> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
>> MVPs and experts. ON SALE this month only -- learn more at:
>> http://p.sf.net/sfu/learnnow-d2d
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET <http://asp.net/>, C#
> 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnnow-d2d
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>