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

Home -> Community -> Usenet -> c.d.o.server -> Re: external function problem

Re: external function problem

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Thu, 20 May 1999 22:57:43 +0100
Message-ID: <7i1t55$3v9$1@news.inet.tele.dk>


Try with BINARY_INTEGER or PLS_INTEGER.

HTH. Finn

Fredrik Antonsson <pt96fan_at_student.hk-r.se> wrote in message news:MvX03.27$Gbn.184427520_at_newsb.telia.net...
> Hi,
> I call an external function in oracle8 in a trigger like this (where
> converter is the lib) :
>
> value1 float;
> value2 float;
>
> converter.myfunktion(value1, value2);
>
> new:myval1 := value1;
> new:myval 2 := value2;
>
> The function is a c function which sets the values by reference. It works
> fine when I work with floats but I would like to use int instead but this
> doesn't work. What shall I declare value1 and value2 as when I wish to
send
> them as integers, I have tried a couple of different datatypes but the
only
> thing I gets back from the c function is 0. Can it bee somthing I have to
> change in the c-function, can't I return the values as int by reference in
> the c-function?
>
> Fredrik Antonsson, Ronneby - Sweden
>
>
Received on Thu May 20 1999 - 16:57:43 CDT

Original text of this message

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