Search notes:

Oracle: UTL_LMS

utl_lms retrieves and formats messages.

get_message

set serveroutput on

declare
   msg varchar2(256);
   rc  pls_integer;
begin
   rc := utl_lms.get_message(2273, 'rdbms', 'ora', 'german', msg);
   dbms_output.put_line('rc  = ' || rc);
   dbms_output.put_line('msg = ' || msg);
end;
/
--
-- rc  = 0
-- msg = Einige Fremdschlüssel beziehen sich auf diesen Primär-/eindeutigen Schlüssel
Compare with sqlerrm.
See also Error messages.

format_message

Note the ellipis (...) in the definition of the function format_message:
function format_message(
   format in varchar2 character set any_cs,
   args ...
)

See also

Oracle UTL packages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759980704, '216.73.216.133', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/utl/lms/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78