| How to load data from excel to OWB....!!! Urgent. [message #186998] |
Thu, 10 August 2006 08:35  |
gowthamsen
Messages: 14
Registered: August 2006
|
Junior Member |
|
|
The steps I followed was
1) I created DSN for my Excel File as ODBC2XL ( I configure the Excel file which is available in my Desktop.)
2) I created initExcel_SID.ora file in the d:\oracle9i\ora9\hs\admin
such as
HS_FDS_CONNECT_INFO = odbc_excel
HS_AUTOREGISTER = TRUE
HS_DB_NAME = hsodbc
3) I created listener in d:\oracle9i\ora9\NETWORK\ADMIN
such as
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = Excel_SID)
(ORACLE_HOME = d:\oracle9i\ora9)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle9i\ora9)
)
)
4) Then I created an ODBC Source Module and a Database Link
Such as
DB Link Name : EXcel_dblink
Host Name : localhost (I am running at server)
Port Number : 1521
Oracle Service Name : Excel_SID
Enable the Use for Heterogeneous Services
User Name : user
Password : user
If I test this, i got following error.
Testing ....
success..
After mapping is created and at the time of deployment I got 6 warnings
They are
ORA-06550: line 16, column 25:
PL/SQL: ORA-04052: error occurred when looking up remote object <unspecified>.Sheet1$@EXCEL_SID.US.ORACLE.COM@DEST_LOCATION_EXCEL_SOURCE_LOC
ORA-00604: error occurred at recursive SQL level 1
ORA-02019: connection description for remote database not found
Its very urgent for my application....
Thanks and regards
gowtham sen.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
