Re: Calling procedures inside packages in Oracle from Delphi

In article ,
  "Billy Verreynne" wrote:
>
> Magnus S. Petersen wrote in message ...
> >I have recently started with packages in Personal Oracle7.
> >I am working with Delphi 2 C/S and cannot figure out how to
> >call the modules inside the packages.
> >It seem as if i cannot use the component StoredProcedure directly, as the
> >database package.function/procedure does not appear in the list.
> >Am i doing something wrong or is it really necessary to use TQUERY
 component
> >to call the modules.
>
> I never use any data controls/classes in Delphi but TQUERY - this gives me
> complete control over the SQL statements. Special db classes (databound
> controls) like TTABLE and TSTOREDPROC have internal SQL statements for their
> methods, which may or may not be the best/optimal for a particular database.
> And you only discover which it is (optimal SQL or not) when the app is in
> production and you get very irate users because of bad performance. Same
> applies to VB programs - we only used snapshots and execsql and stayed away
> for the other db objects.
>
> I suggest using TQUERY only. You can also write a little stored proc wrapper
> for TQUERY that is Oracle specific/optimised. That's why I love Delphi - if
> you want to create a new class it's very easy. :-)
>
> regards,
> Billy

I have had success using the TSTOREDPROC component. The way to get Delphi to see the stored procedure is to set up a synonym within Oracle for the stored procedure.

Mike Hall

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet