error ora-24338 happened when change data source on crystal

building reports crystal reports
1

Hi Guys:
I made a report on my test envariment (this report involve stored procedure and it return a ref cursor from oracle database to the report). after i test it, i decided to move this report to the production database. However when i updated the database location, it shows me the following error:
database connector error: ‘ORA-24338’: statement handle not executed [database wender code: 24338]

then it shows:
some tables could not be replaced, as no match was found in the new data source. please spacify the table required for any unmodified tables.

then it shows:
database connection error

all the tables and code in test database and production database are same.

anyone can help me?

thanks
Howard

abyss :australia: (BOB member since 2009-12-17)

2

Is the stored procedure available on production database ? Its looking for some tables that either do not exists in PROD or you SP may need some slight changes.

Run the stored procedure from SQL*PLUS in PROD environment to find any issues exists.

BO_Chief :us: (BOB member since 2004-06-06)