> > 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:
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;
Leonardo M. Ramé
http://leonardorame.blogspot.com
____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total
Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
