error ora-24338 happened when change data source on crystal report

[Former Member]

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

[Former Member · Accepted solution]

after you went to database

set datasource location

updated it.

did a mapping box come up

did you then verify the database to pull in the new records or tables?

i would run the query on the server to see if it returns values.

you may also need to set your overqualified table name

database

set datasource

locate the table or sp in the top box

the + next to the sp or table

click

open properities +

overqualified table name F2

enter the table or sp in there

then verify your database and try to run against the prod server

[Former Member · Accepted solution]

also do a search on the vendor code i found a few things