How to return a recordset when calling a stored procedure in delphi

Connecting oracle's stored procedure with Delphi's tadostoreprocedure works executable, I've used it a few times, it's just that my stored procedure is written in the middle of the three layers, and I don't return a dataset.

You can define the data you put back as a multidimensional array, and return ** as follows:'ny').value:=ny;

What is your data engine? Generally, you can connect to Oracle through tools such as UNIDAC and ODAC, so that the controls provided by the engine can directly run stored procedures and return results.

When writing the SQL statement of the query control, it is written like this:

declare @r int

exec @r = myproc

select @r as result

Then open, read the value of the result field with fieldbynmae.

outputDate is a parameter of type to be defined in the stored procedure. := ' declare @outputdata int '##10'excute storedproc1 @outputdata output'##10'select @outputdata ';select @outputdate returns a set of knots, just like a table, with only one field and one record. yes.

For example, if the last line of the stored procedure is a select statement (which returns the set), it can be opened with open. Records and parameters are returned at the same time. Otherwise, only the arguments are returned.

time1').value := now;result :

@get1').value;View the original post

Stored procedures: create procedure proc loginusername varchar(20), password varchar(20).

asdeclare @result intselect @result=count(*)from table1 where user=@username and pass=@password

if @result=0

return 0

return 1

godelphi**：

var ret:integer;

with adostoredproc1 dobeginclose;

procedurename:='proc_login';;;

username').value:= ;

password').value:= ;

execproc;

ret:= '@return_value').value;

end;if ret=1 The user Liang Shen Yu respects the paragraph name and password matches.

begin the you want. end

You should want to return a result set, if you do, you can refer to the following with adoquery do

beginclose;

execute proc_rsj_sel ..Fill in the relevant parameters here, and I won't go into detail');

open;end;