AB-Tools.com

Forum Forum



New reply on

Bug if Code Lines Counter reading PL/SQL file
Sven, 2010-04-12 16:25:16
If I use mySQL language then the count reports wrong since my code has line comment inside block comment
Example:
>>>>>>>>>>>>>>
CREATE OR REPLACE TRIGGER y
BEFORE INSERT OR UPDATE ON x
FOR EACH ROW
/*-----------------------------------------------------------------------------
History:

When: Who: What:
-------- ---- ---------------------------------------------------------------
20100101 SVB Initial version

-------------------------------------------------------------------------------
Copyright © 2010 Company. All Rights Reserved.
-----------------------------------------------------------------------------*/
DECLARE

ll_tmp PLS_INTEGER;
BEGIN
if INSERTING then
if ( :new.y_id IS NULL ) OR ( :new.y_id < 1 ) then
ll_tmp := 1;
:new.y_id := ll_PKId;
end if;
:new.createddate := TRUNC( SYSDATE );
:new.updateddate := TRUNC( SYSDATE );
else
:new.createdbyid := :old.createdbyid;
:new.createddate := :old.createddate;
:new.updateddate := TRUNC( SYSDATE );
end if;
:new.xvalue := LOWER( REPLACE( :new.xvalue, ' ' ) );
:new.xdesc := functionyyy( :new.xdesc );
END;
/



Name
E-mail
Subject
Text
Newsletter I would like to be informed about news.
 

© Copyright 1999-2017 AB-Tools.com GmbH · AB-SoftCon.net

Deutsch English Español Français Polski