Database Topics
Access denied for user ‘root’@’localhost’
In mysql, Access denied for user ‘root’@’localhost’ error is due to the root user not having sufficient privilege to access the database. Either the root user password is incorrect, or the root user password is not set, or the root
Can’t connect to MySQL server on localhost
In mysql, Can’t connect to MySQL server on localhost error occurs when mysql is unable to connect to localhost due to the connection issue with mysql or a database configuration issue with mysql. You may see an error Can’t connect
ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06502: PL/SQL: numeric or value error: number precision too large error occurs when the numeric value exceeds the declared numeric data type size. The number of digits in the value exceeds the number of digits in the declared numeric data
ORA-06502: PL/SQL: numeric or value error: character to number conversion
ORA-06502: PL/SQL: numeric or value error: character to number conversion error occurs when a character value is assigned to a numeric variable in the oracle PL/SQL code. When a non-numeric value is assigned to a numeric datatype variable, the character
ORA-06502: PL/SQL: numeric or value error: character string buffer too
ORA-06502: PL/SQL: numeric or value error: character string buffer too small error occurs when the length of the character string exceeds the length of the declared character type variable,. The value cannot be assigned to the variable if the size
ORA-06502: PL/SQL: numeric or value error
ORA-06502: PL/SQL: numeric or value error error occurs when the not null variable is assigned a null value or when the assigned numeric value is greater than the allowed numeric datatype value or when a non-numeric value is assigned to
ORA-06512: at line
ORA-06512 error message specifies the line number where the exception occurred in the oracle code, but not the cause of the exception. When troubleshooting, the ORA 06512 error is really helpful. ORA-06512: at line is part of the error stack.
ORA-06530: Reference to uninitialized composite
The ORA-06530: Reference to uninitialized composite error occurs when an object, LOB, or other composite was referenced as a left hand side without having been initialized. When a reference to an uninitialised object, LOB or composite is used to assign
DBMS_OUTPUT.PUT_LINE not printing
DBMS_OUTPUT.PUT_LINE not printing – The dbms_output.put_line command is used to print the output of PL/SQL code in the console window in oracle sql developer and sql plus. The dbms_output.put_line command will not be working or printing in the sql developer
PLS-00201: identifier must be declared
The PLS-00201: identifier must be declared error happens when the identifier is used without being declared in the PL/SQL code. Oracle Variables and other identifiers must either be declared or made available before they’ve been used. The variable is used