Live SQL

UTL_LMS - PL/SQL and SQL

View All Public Scripts Login to Run Script

Script Name UTL_LMS - PL/SQL and SQL
Visibility Unlisted - anyone with the share link can access
Description Showcase of UTL_LMS not working in SQL directly
Contributor Pesse
Created Wednesday January 27, 2021

Statement 1

begin 
    dbms_output.put_line(utl_lms.format_message('Test %s', 'something')); 
end;

Statement processed.
Test something

Statement 2

select utl_lms.format_message('Test %s', 'something') msg from dual

ORA-00902: invalid datatype

More Details: https://docs.oracle.com/error-help/db/ora-00902

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database