ORA-01722 Invalid Number

ORA-01722 Invalid Number

ORA-01722 Invalid Number This error occurs when you try to convert a character string into a number, and the string can’t be converted into a valid number. So what is a valid number you ask? A valid number to Oracle would be a digit between 0-9, a negative or...
ORA-00600

ORA-00600

The ORA-600 is an internal Oracle error that can be reported by a very serious error. A lot of times this error can’t be solved by an onsite DBA and needs direct help from Oracle to help troubleshoot the issue. If the trace files from the error don’t prove...
Tip for debugging shell scripts

Tip for debugging shell scripts

Often enough I have to mess around with shell scripts and even more often I have to spend a considerable amount of time debugging scripts. Though whenever I find myself having to debug a script I often use this little bit of code to help me step through my code to...