Cursor variables

[Rocker]

I wrote a query. If I place it into SQL property of TOracleDataSet, then it executes just one second, but if I place it into the package as ref cursor, it executes 15 seconds and above. I use the following script to call the procedure:
begin
stfrep.getpodkat(pdat1 =>

dat1,
pdat2 =>

dat2,
c => :c);
end;
Can anybody help me to do this problem?
Thanks a lot.

 

[Marco Kalter]

Do the 2 queries have the same variables and the same result set (e.g. the same number of records)?

If so, you may want to use tkprof to compare the query execution plans of both queries.

------------------
Marco Kalter
Allround Automations