I am switching Databases in Crystal Reports 9 in runtime using Report Designer Component (craxdrt9.dll)
Crystal Reports refer to Oracle stored procedure that has SQL statement :
WHERE EXISTS (SELECT *
During running I've got error:
Fail to execute SQL statement. OCI Call: OCIStmtExecute
When I've changed SQL in Oracle stored procedure to
no exception occurred.
Is it correct behavior of Crystal Report Designer Component?
What are the syntax requirements for Oracle stored procedures that are called from Crystal Report?