Hello experts,
when i am trying to create a force view , Could not understand where exactly the issue is, rechecked with syntax but did not found any issue,
can you please advise what need to be checked when the below occours
i am getting the below error
SQL Command: force view K6_DATAMART.DM_PROMO_HISTORY
Failed: ORA-24344: success with compilation error
24344. 00000 - "success with compilation error"
*Cause: A sql/plsql compilation error occurred.
*Action: Return OCI_SUCCESS_WITH_INFO along with the error code