reports compatibility issue

[denevge]

Hi everyone,
I have a very strange problem deploying reports.

I have a db A, that runs on 817 NT.
I have a db B, that runs on 817 AIX.

When i compile the report against db A, I can successfully run the report connected to db A but when I run it connected to db B it hangs. --> 100% CPU utilisation on the client ( NT4 Workstation )

When i compile the same report against db B, I can successfully run the report connected to db B, but when I run in connected to db A it hangs.

I compile the report in reports builder. Then I create a REP file that is saved to disk. I start the report using a forms-application. So, the way I run the report is always the same, only the db I connect to is different.

On db A and db B the NET8 listener is used.

It resembles http://www.dbasupport.com/forums/sho...threadid=12287, but they're was no solution in this thread.

Anyone an idea ?
I also made an iTAR with oracle support.

Gert

[denevge]

We located the problem ourselves.

In the report, we have a BeforeReport function.
In this function, we call a report Packaged Function m_init.f_init(... ) that itselfs calls a db packaged function.

When we create a report function ( not in a package ) f_init, instead of the packaged function, and we use this function in the BeforeReport function, everything seems to be OK.

Looks like a bug in reports to me.
I will keep you informed about what oracle support has to say.

Regards
Gert