Sergio Samayoa wrote : >I just began to use SAPDB. I have strong backgroun on RDBMS (Oracle and >Interbase mainly) and found that stored procedures and triggers in SAPDB has >just 255 lines limit. Why? Also, sp and triggers are compiled and stored as >p-code or alike (BLR for example) or they are interpreted at execution time.
1. There is no 255 lines limit for stored procedures. From the SAPDB kernel point of view a dbproc definition isn't grouped into lines, instead it is viewed as one buffer containing a sql statement. The length of a stored procedure definition therefore is just limited by the length of the communication packet. You may have to increase the parameter _PACKET_SIZE to be able to create your stored procedure. 2. DB-Procedures and Triggers are compiled into p-code. Regards Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
