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 _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
