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.
Untested:
If your stored procedure returns a recordset simply do:
Untested:
If your stored procedure returns a recordset simply do:
query.SQL.Text := 'select * from your_stored_sp';
query.Open;
If the SP does not returns a resultset do:
query.SQL.Text := 'execute your_stored_sp(''param1'', ''param2'')';
query.ExecSql;
That's what
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
Wow, so there is actually someone using the oracle-connection... I
thought I only made it for pr-purposes. ;)
This is my first time experience with Oracle using FPC. I'm now using
FPC 2.2.1 and Lazarus 9.24.1. :-D
Btw: fcl-db contains all the TDataset-based components. Also TDataset
itself
For SF, Oracle returns the output as row. To call SF, I'm using call
sf_name from dual. But, I found the output of SF is not compatible
with TDataSource, and it raises an AV too.
Sorry, my mistake. I mean select sf_name from dual.
-Bee-
has Bee.ography at:
http://beeography.wordpress.com