[fpc-pascal] fcl-db: oracle SP

Bee bisma at brawijaya.ac.id
Tue Apr 8 11:38:10 CEST 2008


> Below is a simple Oracle sample  :

Thanks, your advice is indeed working using TOracleConnection and 
TSQLQuery. But, I got performance overhead using this trick. Pipelined 
function took 16 ms while default SF/SP for same result took less than 1 ms.

So, the thing we should fix is to make sqlDB supports Oracle's default 
SP/SF and get the best performance out of it. ;)

-Bee-

has Bee.ography at:
http://beeography.wordpress.com




More information about the fpc-pascal mailing list