Getting error while trying to get more records in HTML

[inu]

Hi Team,

I ran one report, got data as well, But if i click on "page down" for other more records , it throws error (blob error), please find the attached screen shot.

Can you please suggest me in this regards

Regards
Inam

[MFGF]

Hi Team,

I ran one report, got data as well, But if i click on "page down" for other more records , it throws error (blob error), please find the attached screen shot.

Can you please suggest me in this regards

Regards
Inam

It's an error from Oracle saying that an argument you are passing in a function call is not valid.

MF.

[xyz]

Hi Inam,

We get this kind of error in Cognos, because of the data type for  particular column is set a BLOB in the database, which takes lot of space, basically I use sql server as my database, If I encounter such kind of error in cognos, in order to overcome the error I cast particular to some defined size. Example given below

cast(column, varchar(100))


Thanks & Regards,
XYZ