In a script I have a prompt command that writes a helpful message to a spool file. The final character to be displayed by the command is a semicolon (;). The semicolon is not being displayed. The same thing happens when I execute the command from a SQL*Plus command line. Here is the command and its output:
SQL> PROMPT seeks to access: SELECT * FROM <table_name> WHERE rowid='<rowid>';
seeks to access: SELECT * FROM <table_name> WHERE rowid='<rowid>'
Can anyone tell me why the semicolon is not being displayed, and what I have to do to make it appear?
Thanks,
Bill