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

[Anthony T. <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, 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
>
>