[fpc-pascal] fcl-db: oracle SP

[Joost van der Sluis]

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.