To pass values to and from a foreign function in Oracle D2K, you can use th

how can you pass values to-and-fro from foreign function?

Question Posted / Anilkumarsingh

1 Answers
15 Views
I also Faced
E-Mail Answers

Answer Posted / Anilkumarsingh

To pass values to and from a foreign function in Oracle D2K, you can use the PARAMETERS clause. This clause allows you to specify input parameters (IN) that are sent to the function, output parameters (OUT), and parameters that are both input and output (IN OUT). Here's an example:

```
DECLARE
myFunction (IN out_param1 number, IN out_param2 date);
BEGIN
myFunction(IN_PARAM1 => 5, IN_PARAM2 => SYSDATE);
END;
```

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Were you involved in any data conversion, which one?

Have you used lexical parameters in reports?

Are you familiar with user exits in reports?

Any work done in oracle workflow builder. Did you customize or build a new workflow?

How many concurrent programs you have customized, can you name some of them?