Not able to import all data from oracle

HCL Domino Domino Forum
1

i am trying to import all datas form oracle in lotus notes.but i am only able to access 2313 datas.there are more than 7000 record in oracle i have to import all the datas.Is this possible to import 7 thousand data from oracle to lotus ? pls let me know .

Thanks dear.

2

Subject: not able to import all data from oracle

How are you importing them? Via LEI? Spreadsheet? On the drop down menu or using Lotus Script?

3

Subject: RE: not able to import all data from oracle

i am using lotus script.

4

Subject: RE: not able to import all data from oracle

How? Can you post the relevant bits of code and tell us what’s going on in the debugger?

5

Subject: RE: not able to import all data from oracle

qry.SQL ="select * from table1 " res.Execute

Do		

		res.NextRow

		DCode = res.GetValue("EMP_CODE",ShortName)

		

						End If

	Loop Until res.IsEndOfData	

	Set doc = view.GetNextDocument(doc)

Wend
6

Subject: RE: not able to import all data from oracle

I assume you’re using Uselsx “*LSXLC” for this. If that’s the case, you may want to check into the ‘fetch’ method. It allows you to pull back part of a results set. I’ve never had to use it, but I recall that it can be used to help manage queries.

I’d recommend you go to the Lotus Enterprise Integrator forum if you get stuck on this one - they specialize in this kind of design.

Doug

7

Subject: RE: not able to import all data from oracle

i have no LEI. Is LEI is another type of server of lotus notes.?I have no idea about LEI so would you guide me ?

8

Subject: RE: not able to import all data from oracle

Not LEI, lsxlc - built in, free, available to everyone.

You really REALLY need to get to the Enterprise Integration forum and ask there. No, search first, then ask. There are lots of code samples all over the place so spend some time looking at how others build code, then try it, then ask.