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 _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
