Oracle Database Views

[MK_QSL]

I am trying to load 150+ oracle views to generate QVDs.

But due to not having access of some views, I am getting insufficient privileges….

Is there any ways that even though above error, the script will keep running and I would have list of all views which having insufficient privileges errors?

[SunilChauhan]

no you can't . you need to have access ateast read only to run those views.

hope this helps

[quwok]

Try adding the following to the top of your load script

Set ErrorMode=0;

This will tell QlikView to ignore errors and continue processing the script.

[SunilChauhan]

i am agree with him

errormode=0 means it will not give errror on any error occurance in script;

but it also mean that error code data will not be  available .

i thing it fit to your requirement.

[MK_QSL]

I am currently running with Set ErrorMode = 0.

Let some other GURUs to reply...