Re: How to call a stored function from Delphi3

From: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: Mon, 18 May 1998 10:04:39 +0200
Message-ID: <355FEB96.DADB3558@bitoek.uni-bayreuth.de>

Magnus S. Petersen wrote:

> Using Delphi3 and Personal Oracle
> I am regularly using TStoredProc in Delphi to call stored procedures
> either as stand alone or within packages. It works fine.
> Recently i tried to call a function within a package, but it gives me
> problems. The function has as input a couple of formal parameters and
> its return value is Varchar2.

Thus you must set the Resulttype to string. Typ Result is for real Resultsets (Cursors) inwhich you have functions like next, last, etc.

> snip
>
> Regards
> Magnus

Helmut Received on Mon May 18 1998 - 03:04:39 CDT