1
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • Parameter Manipulation – Turning ‘abc’ type string into a number

    I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ' - ' || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN...

    tmbdnelson70 pointsBadges:
  • ORA-07445

    Hi, I got the following error and my Instance went down. Can any one help me out to solve this error. Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x17a, PC: [0x100ff7428, 0000000100FF7428] *** 2008-02-16 05:12:08.804 ksedmp: internal or fatal error ORA-07445:...

    Thedevil5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following