Migrating an OUD 11g Proxy that has a working configuration of RDBMS Workflow Element against an Informix DB to 12c.Īttempting to create an RDBMS attribute mapping fails:
Information in this document applies to any platform.
Oracle Unified Directory - Version 12.2.05 and later SQL> CREATE OR REPLACE PROCEDURE TestProcĪnd now when we execute our TestProc procedure, the ORA-06512 error has been resolved.OUD 12c Proxy - Creating RDBMS Attribute Mapping for Informix DB Fails with "LDAP: error code 53" "An error occurred while configuring the Database Session for the WorkflowElement" "Routine (get_data_type) can not be resolved" You could correct this by writing an exception handler to set the v_number variable to 99 (so that it is only 2 digits) when this error occurs. In this example, you've tried to assign a 3 digit number to a variable called v_number that can only handle 2 digits. Let's look at an example of how to resolve an ORA-06512 error by writing an exception handler. SQL> CREATE OR REPLACE PROCEDURE TestProcĪnd now when we execute our TestProc procedure, the ORA-06512 error has been resolved. You could correct this error by redefining the v_number variable as number(3). The first line of the error message (ie: ORA-06502) indicates the error that occurred, while the second line of the error message (ie: ORA-06512) indicates that the error occurred at line 5 of the PLSQL code. ORA-06502: PL/SQL: numeric or value error: number precision too large But when we try to execute this procedure, we will get an ORA-06512 error as follows: SQL> execute TestProc() Let's look at an example of how to resolve an ORA-06512 error by fixing the error condition.įor example, if you created a procedure called TestProc as follows: SQL> CREATE OR REPLACE PROCEDURE TestProc Resolution Option #1 - Fix the Error Condition
0 kommentar(er)
