How to call an oracle function ? 
Author Message
 How to call an oracle function ?

Hi

Yes, I would like to call an oracle function I defined, and get the
result back.
Any idea?

In sql, the syntax is

declare v_res number
begin
  v_res := f_my_function(10);
end;

How can I get v_res back in delphi ?

- Eric -

*----------------------------------------------------------*
Bole-Feysot Eric - BOBST SA - Switzerland


*----------------------------------------------------------*



Wed, 18 Jun 1902 08:00:00 GMT  
 How to call an oracle function ?

Here one example

Select
  f_my_function(10)  v_res
From Dual

Try running this SQL in a TQuery Component and you will get the result that
you are looking for!

Regards

Colin Dawson

http://www.athene.co.uk/homepages/cdawson

begin 666 Colin Dawson.vcf


M97!A9V5S+V-D87=S;VX-"D5-04E,.U!2148[24Y415).150Z8V1A=W-O;D!A
M=&AE;F4N8V\N=6L-"E)%5CHQ.3DX,#0R.%0Q.#0P,#9:#0I%3D0Z5D-!4D0-

`
end
end



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How should I call Personal Oracle 7.2 stored procedure (or function)

2. Dll function call

3. Help With Pascal Iwant to call C function from Pascal

4. Microsoft SQLServer calls BDE-callback function

5. Calling codebase dll functions from another dll

6. Calling Functions in DLL's

7. Calling C functions

8. Calling main function

9. How to call a BIOS function...

10. how do I call Pascal functions from C?

11. calling Turbo Pascal functions from Borland C++ builder

12. how do I call Pascal functions from C?

 

 
Powered by phpBB® Forum Software