Re: Accessing Oracle Packages from Delphi

From: Nuno Guerreiro <nuno-v-guerreiro_at_telecom.pt>
Date: 1998/04/29
Message-ID: <3546ec3d.669196764@news.telecom.pt>#1/1

On 28 Apr 1998 16:10:39 EDT, Nnoor_at_cris.com (NNOOR) wrote:

>
>Hi,
>Can someone give me an example of accessing an Oracle DBMS_ package
>from Delphi? I am interested in DBMS_ALERT package. I can call it's
>register and remove procedures using TQuery (enclose the statement
>in a begin-end block). But commands like WAIT and WAITONE are problem
>as they are supposed to read back the result as well. How to do it?
>
>
>Thanks and Regards,
>Nasir (nnoor_at_cris.com)

I think you'd better use the Stored Procedure component in the Data Access tab. You can specify the stored procedure name (preceded by the package name), specify which parameters it needs and it should work. I've already done this but it was a long time, so I don't remember the exact details.

Good luck,

Nuno Guerreiro Received on Wed Apr 29 1998 - 00:00:00 CDT