plsqldoc - SP2-0734 in SQL*Plus

[D.]

Hi,

When creating documentation tags using plsqldoc, i have inserted certain tags (eg. #AUTHOR) inside a /* .... */ comment block. The author tag is on a line by itself, with the '#' as the first character on the line. Through PLSQL Devloper this is fine, generates great documentation and compiles successfully. But when running the same script through SQL*Plus, you get:

SP2-0734: unknown command beginning "AUTHOR" - rest of line ignored.

This doesn't happen if you put a space before the '#'. Any clue as to why SQL*Plus would be interpreting this as a command when it's inside a comment block ?

Offending code below ...

CREATE OR REPLACE PACKAGE test_pkg AS
/******
SYNOPSIS: One sentence end with a full stop.

#AUTHOR author.
*******/

END test_pkg;
/

Thanks,
D.

 

[D.]

OK, found out why this is happening...

There is a setting within SQL*Plus called "SQLPREFIX" which is by default set to a hash '#'. By simply setting this off "set SQLPREFIX OFF", it no longer complains.

Maybe this could be documented in the plsqldoc manual.

Have a nice day .....

 

[Marco Kalter]

Hmm, this only occurs if the # is on position 1. Maybe we should use a different tag character.