M
M
marselabdullin2020-10-21 15:13:58
Oracle
marselabdullin, 2020-10-21 15:13:58

Expecting number loading given in SQL?

I have a spreadsheet with data in excel, I need to load it into pl/sql(spark).
I created the table itself through python, but it doesn’t work to load data into it, because the error "expecting number" comes out
Even when I create a table with only the char type, it still says that it expects a number I will
attach a fragment of the script and the error itself ( I immediately apologize for photo and quality, there was no other way to insert the code ).

Perhaps this is due to the executemany function itself

5f902664bd021190335783.jpeg alt="image"/>

5f9026746b85a993828189.jpeg

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question