About cboothroyd

cboothroyd · 01-29-2024

Hi,I am experiencing an error while trying to connect to an Oracle stored procedure. This happens only in the report designer, not at run-time. The scenario is this:Open an existing report (that works at run time)Open Field ExplorerRight-Click and ...

cboothroyd · 07-14-2021

I am trying to connect Crystal to an Oracle Data source. Everything works at run time (and preview) but if I try to use the Database Expert or Update Data Source it does not. I have tried on multiple machines (including a clean build of Windows) – ...

cboothroyd · 02-01-2024

Also, we just figured out the problem earlier. With the help of an Oracle DB we were able to establish that the user account was unable to execute the stored procedure when it is prefaced with the schema name - but Crystal forces the schema name. e.g...

cboothroyd · 02-01-2024

Thanks for the response. Just FYI, all the components I am using are issued by Oracle (downloaded from here: https://www.oracle.com/database/technologies/net-downloads.html#).

cboothroyd · 07-14-2021

Hi Dell,Yes, the oracle client bin directory (C:\app\bin) is in the path but I only have the 64 bit client on this machine - so nothing to swap. (I did have both on another machine but swapping didn't help on that machine).Both of the Oracle networki...

cboothroyd · 07-14-2021

Hi Dell,Thank you for your quick response. I am using the native connection (Oracle Server). I was pretty sure that I tried the Oracle 64 bit client with Crystal 2020 but just to be sure, I tried it again on a clean build of Windows 10. I just ins...

User Statistics

User Activity

Connecting to Oracle Stored Procedure (00302: component must be declared)

Connecting to Oracle DB

Re: Connecting to Oracle Stored Procedure (00302: compone...

Re: Connecting to Oracle Stored Procedure (00302: compone...

Re: Connecting to Oracle DB

Re: Connecting to Oracle DB