Trying to Use Oracle 8i Stored Procedure

[ChiTownDiva]

I'm trying to use an Oracle Stored Procedure and when I try to add it I get the following message:

"ORA-06564: object does not exist".

What is the deal?

Thanks in advance...

ChiTownDiva

 

[synapsevampire]

What version of Crystal, and what type of connectivity?

Crystal is very particular about using SP's, and you must use Crystal's ODBC or direct connectivity, not Oracles ODBC.

Check this or post more details:

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

-k

 

[ChiTownDiva]

Thanks synapsevampire...

I am using Crystal's ODBC. I tried reading the technical papers on the link and got nothing out of it.

Thanks.

ChiTownDivaus

 

[SurfingGecko]

Make sure you have rights to access this proc. This is what I found on Google

http://www.csee.umbc.edu/help/oracle8/server.815/a67785/e4100.htm

..........
Cause: The named object could not be found. Either it does not exist or you do not have permission to access it.

Action: Create the object or get permission to access it.
..........

Haven't seen this before so hope this helps.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

 

[ChiTownDiva]

I'm lost...

I can run this procedure from SQLPlus, so I assume I have permissions to run procedures...

How do you "create the object"?

Thanks.

ChiTownDivaus

 

[synapsevampire]

Just because the SP runs from SQL Plus doesn't mean that it will work with Crystal, Crystal requires a certain format, and the version of Crystal makes a difference too.

The above link should describe the particulars, it's annoying but doable.

-k

 

[Naith]

Hey ChiTownDiva,

"Object does not exist" is a very specific error, which can only be one of two things: (1) the object you're trying to query really doesn't exist (2) the user trying to query the object doesn't have the relevant privileges to see the object, as SurfingGecko has pointed out.

Because you say you can query the object successfully in your client, I'm presuming it can't be (1) - so it must be (2). When you test execution from the client, are you logging on with the same user Crystal is using to execute the report?

I'm pretty sure I've seen you post before regarding Oracle SPs, so I'm going to assume that you've read the whitepaper mentioned in this thread. But if you haven't yet, it's critical that you do follow the DOs and DO NOTs set out in the paper.

Naith

 

[ChiTownDiva]

Hi Naith and Synapsevampire...

Yes, I'm logging onto Crystal the same was as before. Supposedly permission was given to the same User ID we use to design and run reports.

Yes, I read the White Paper mentioned in the thread...unfortunately, I didn't write the procedure. The company I work for farms out their IT work to another company. I'm just the reports/data analyst trying to use whatever is given to me. I did give a the link with the whitepaper to the programmer who wrote the procedure, so I assume he read it and designed it accordingly...

ChiTownDivaus

 

[lyanch]

Can you visibly look at the actual stored proc .. If you have run access you probably have view access.. or even ask for a printout..

look for things that happen in execute immediates usually.. table (or temp table) creation.. execution of another stored proc etc.. Those all cause Crystal to have problems with the SP.

Lisa

 

[lyanch]

Oh... one other thought.. does your tool use the same SQL connection that Crystal uses?

Lisa