60 pts.
 Database Connection Error
When I opened a crystal report from design mode to Preview mode It thrown this error:’’Database Connection Error:’Cannot obtain Error message from server’ and, ODBC Error(Merant) ODBC Oracle 8 Driver ORA-06550:Line1,Column8,PLS-00201:identifier’xxx.PRC_RI_REPORT’Must be Declared ORA-06550:line1, column 8: pl/sql Statement ignored Error Detected by Database DLL And,Database Connection Error

Software/Hardware used:
ASKED: March 4, 2009  2:09 PM
UPDATED: March 4, 2009  2:36 PM

Answer Wiki:
You are probably calling a stored procedure (PRC_RI_REPORT) that does not exist in the package xxx in the Oracle database. If you are sure that both the package and the procedure exist, you may need to grant execute privileges to the package, and call the procedure this way if the connected user is not the owner of the package: <owner>.<package>.<procedure>. Alternatively, you could create a synonym, so you do not need to specify the owner when calling the package.
Last Wiki Answer Submitted:  March 4, 2009  2:36 pm  by  carlosdl   63,580 pts.
All Answer Wiki Contributors:  carlosdl   63,580 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _