Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A "Select from procedure" problem - Oracle and DELPHI

Re: A "Select from procedure" problem - Oracle and DELPHI

From: Robert M. Kopf <rkopf_at_mapmobile.com>
Date: Thu, 04 Feb 1999 14:13:43 GMT
Message-ID: <79c9ud$hmb$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US