[fpc-pascal] fcl-db: oracle SP

[Bee]

> 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 common db engines do. But not with oracle. Yes, I tested 
them. :( For SP with no return value(s), simply do "call 
sp_name<input_param_list>" is working perfectly. But if the SP involves 
out param and/or cursor, none of "common" method is working. :(

-Bee-

has Bee.ography at:
http://beeography.wordpress.com