How can we use orastoredproc?

Dastan · Post by **Dastan** » Thu 20 Apr 2006 10:39

I would like to ask about the orastoredproc component, how can i use it? why when i put into storedprocname my working procedure there comes "SQL statement doesn't return rows". why?

Challenger · Post by **Challenger** » Thu 20 Apr 2006 12:07

Please check that you are calling Execute method of TOraStoredProc.

Dastan · Post by **Dastan** » Fri 21 Apr 2006 07:59

when i write orastoredproc.execute it dioesn't do anything, but when i do
orastoredproc.active:=true "sql statement doesn't return rows mistake" comes.What is wrong?

Challenger · Post by **Challenger** » Fri 21 Apr 2006 11:28

This error is being raised because your stored procedure doesn't have out parameters of type CURSOR. Please refer to ODAC StoredProc demo. If you don't find any solution please send to ODAC support address complete sample that demonstrates this problem and include script to create server objects.