A "Select from procedure" problem - Oracle and DELPHI

From: <leduc_nicole_at_my-dejanews.com>
Date: Thu, 04 Feb 1999 08:24:10 GMT
Message-ID: <79blf5$1li$1@nnrp1.dejanews.com>

Hi Oracle Gurus,

I've got a *big* problem with Oracle : I'm studying a software conversion from Interbase to Oracle (both with Delphi).

The problem is :
with Interbase, u can write : select ... from MyStoredProc. Not possible with Oracle... as far as I know.

Does anybody already have to face to such a problem ? TIA,
Nicole

---

Here's a more complete description for my question, you don't need to know Interbase to understand what the problem is :

Inside the software i'm working on, on his computer window, the User can choose between several buttons, and gets a result (some datas, into a Delphi DBGrid). According to his selection, the Delphi code builds a 'dynamic' SQL statement like this :

select ...
from Table1 T1, Table2 T2..., StoredProc1 SP1, StoredProc2 SP2... where SP1.param1=T1.Column1
and SP1.param2=10 (or 20, or 30...)
and...

So, the stored procedure returns many rows, and works exactly as a table : can be joined, and so on.

I must be careful on 3 points in this challenge ;-) ---> the SQL statement is dynamic, so I must imagine a dynamic solution, I mean, I can't only change ONE sql statement because tables and stored procs used depend on the User's choice ---> I must try to have the same Delphi Code in Interbase and Oracle... or the fewest number of modifications... ---> I must be careful about performances (isn't that new for us DBAs ;-) )

If you have any other idea,
please Gurus, do tell me.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 04 1999 - 02:24:10 CST