Thank you Anhaus, but the 255 limit I did found it at: http://www.sapdb.org/htmhelp/e0/ed9036dfe4b903e10000009b38f889/frameset.htm
Look at the botom of the page. It is oudated or bad the online documentation ? Regards. "Anhaus, Thomas" <[EMAIL PROTECTED]> escribi� en el mensaje 37DE83A2B945D3118B180008C75D3E8D0C2094BB@dewdfx25">news:37DE83A2B945D3118B180008C75D3E8D0C2094BB@dewdfx25... > 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
