Op vrijdag 04-04-2008 om 17:19 uur [tijdzone +0700], schreef Bee: > Hi all, > > Using fcl-db aka sqldb, how to call oracle's stored procedure through > toracleconnection? So far, google can't help me much. :( Or is there a > special component to handle stored procedure as in Delphi? TIA.
Wow, so there is actually someone using the oracle-connection... I thought I only made it for pr-purposes. ;) Btw: fcl-db contains all the TDataset-based components. Also TDataset itself is part of fcl-db. But also TMemDataset and tDbf. If you wanna use some other db-framework like ZEOS you also need fcl-db. sqldb is just one way to use TDataset, it's part of fcl-db, but it's not an alias or something. Just to clear this up. That sqldb doesn't return data from a stored procedure is probably because it only tries to fetch data if the query starts with 'select' or 'show'. I'll have to add 'call' to that list for Oracle and do some tests. Can you submit a bug-report? Joost. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal