Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Load a 37 digit number from file into table using sqlcl load

User_SEI52Sep 21 2021 — edited Sep 21 2021

Hi,
Here's my table
create table id_table (ID number)
Here's my csv file contain 37 digit number (sample.csv).
ID
123456789123456789123456789123456789
I loaded the sample.csv through,
sql -S -L /nolog 2>&1 << EOF
WHENEVER SQLERROR EXIT SQL.SQLCODE
connect $DB_CREDENTIAL
set loadformat delimited delimiter ,
show loadformat
load id_table sample.csv
EOF
No Error in load log. But, when I see the value in the table, the ID column displayed as
123456789123456780000000000000000000

What i'm missing here.
This post has been answered by thatJeffSmith-Oracle on Sep 21 2021
Jump to Answer

Comments

Nik

Hi.

What  message/ log notice you about coorupted FW/ ILOM ?

At this momemnt system detect: Description : Memory DIMMs are not populated.

Check:   How many DIMMS realy installed at server ?  What type ?  What slots populated ?

Try replace DIMMs.  Also may be MB is bad.

Regards,

   Nik

3077498

I've been using system for years now, the problem started when I tried to upgrade to latest firmware (BIOS/ILOM). Unfortunately, I did the firmware upgrade remotely, and I think system did not come back up so I tried to power cycle it remotely. It never came back up.

I haven't touched the DIMMs. I can try to pull them out and then put them back in again.

How can I rule out the BIOS problem (can I recover that somehow?)

1 - 2

Post Details

Added on Sep 21 2021
#load, #oracle, #sql, #sql-developer
3 comments
294 views
1 mention