OraFAQ Forum: Programming Interfaces » Question regarding OLE2....

Home » Open Source » Programming Interfaces » Question regarding OLE2....

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question regarding OLE2.... [message #377608]

Tue, 23 December 2008 20:13

setsuna
Messages: 32
Registered: November 2008

Member

Hi guys,

I am learning to use OLE2 now in PL/SQL and I encountered some strange occurances while loading the data from Excel file into the database.

In some of the column, like 'Date' and 'Quantity'; whenever I load the excel file data into the database, there is a discrepancy between data loaded to the database and those of in Excel file.

E.g: (data in excel)

Date Qty
-------- ---------------- ===> field is formatted into
20081205 100000 general format.

(data in database)

Date Qty
------- -------- ====> (both are varchar2 datatype)
2 1

this problem is solved by using get_num_propety and then convert it to varchar datatype....

My question is, why is there a discrepancy in the data (in database and excel file) and I had used get_num_property instead of get_char_property? why can't the data in excel treated as varchar implicitly? Is there any other method to get the data correctly withouth having to covert from number and to char?

Sorry for the trouble again, especially christmas is near... Embarassed

Report message to a moderator

Question regarding OLE2.... [message #377609 is a reply to message #377608]

Tue, 23 December 2008 20:19

setsuna
Messages: 32
Registered: November 2008

Member

  Date       
--------       
 20081205 

  QTY
----------
1000000

->data are formatted in general format.

---------------------------------------------------
(data in database)

  Date            
-------       
  2

  QTY
--------
  1

====> (both are varchar2 datatype)

this problem is solved by using get_num_propety and then convert it to varchar datatype....

My question is, why is there a discrepancy in the data (in database and excel file) and I had used get_num_property instead of get_char_property? why can't the data in excel treated as varchar implicitly? Is there any other method to get the data correctly withouth having to covert from number and to char?

Sorry for the trouble again, especially Christmas is near... Embarassed

Report message to a moderator

Previous Topic:	Need help in connecting Oracle with PHP Code
Next Topic:	unable to retrieve data from SQL server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 30 03:50:49 CDT 2020