[fpc-pascal] fcl-db: oracle SP

Leonardo M. Ram� martinrame at yahoo.com
Fri Apr 4 14:10:38 CEST 2008


> > 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



More information about the fpc-pascal mailing list