Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A "Select from procedure" problem - Oracle and DELPHI
Oracle requires that stored procedures are executed, not simply selected
from. In Delphi, the TStoredProc component allows for manipulation of stored
procedures. Although this may limit your dynamic SQL building, you should be
able to get around this by dynamically setting the SQL in a TQuery,
dynamically setting the properties of a TStoredProc, inserting the result
values into a second TQuery, and hooking the TDBGrid to the second TQuery.
Robert Kopf
Map Mobile Communications, Inc.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 08:13:43 CST