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...