Page 1 of 1
How can we use orastoredproc?
Posted: Thu 20 Apr 2006 10:39
by Dastan
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?
Posted: Thu 20 Apr 2006 12:07
by Challenger
Please check that you are calling Execute method of TOraStoredProc.
Posted: Fri 21 Apr 2006 07:59
by Dastan
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?
Posted: Fri 21 Apr 2006 11:28
by Challenger
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.