Stored procedures slow it down

[tsusnik]

I haven't been using stored procedures till now. Now I am connecting to the database and want to include stored procedures. It takes several minutes before the connection is established on one database and so long I didn't wait on another (both Oracle)! If I don't include stored procedures the connection is established in one or two seconds. Is this happening to others too or is it my mistake?

Thanks for any advice!

Tomaz

 

[Hm786]

This happens to me and another programmer of my team. If I am not using the procedure then I get connected to the database quickly. I think it is some kind of bug with crystal itself.


Hamida

 

[tsusnik]

It's working fine now.

Some hints for those that still have problems:

- make sure you have the file cror815.dll in winnt\system32\, not any old version

- create an ODBC connection using that file (not an old one)

- check "Procedure returns results" !!

Hope This will help someone.

Regards, Tomaz