set location for oracle stored procedure using crystal 8.0
Posted on 2003-10-27
I'm trying to change the location of an oracle stored procedure using Crystal Reports 8.0. I cannot see the stored procedure when I connect to the new server. The dba has set up the package and procedures as public synonyms. He has granted execute rights to the procedure(s) also, but I still cannot see them. Any ideas what else has to be set in order to attach to the new server? On the original test server, I can attach to the procedure as both a schema owner and a user, but I can't find the differences in the user on the original test server and the new server.