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.co
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 i
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, s
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 comm
> > 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
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.
I'm using Oracle 10g, FPC 2.2.1, on Ubuntu 386.
-Bee-
has Bee.ography at:
http://beeogra
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.
-Bee-
has Bee.ography at:
http://beeography.wordpress.com
_
