|
||||
Forum| 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; / |
|
© Copyright 1999-2024 AB-Tools GmbH · AB-SoftCon.net
|
