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

1 Answer

Answer :

Yes . You obtain a return value from a foreign function by assigning the
return value to an Oracle Forms variable or item. Make sure that the
Oracle Forms variable or item is the same data type as the return
value from the foreign function.
After assigning an Oracle Forms variable or item value to a PL/SQL
variable, pass the PL/SQL variable as a parameter value in the PL/SQL
interface of the foreign function. The PL/SQL variable that is passed as
a parameter must be a valid PL/SQL data type; it must also be the
appropriate parameter type as defined in the PL/SQL interface.

Related questions

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?

Last Answer : Break. SYSTEM VARIABLES

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

Description : What are the values that can be specified for OPTIMIZER MODE Parameter ?

Last Answer : COST and RULE.

Description : Can the default values be assigned to actual parameters?

Last Answer : Yes

Description : What are the two ways by which data can be generated for a parameters list of values?

Last Answer : 1. Using static values. 2. Writing select statement.

Description : How can values be passed bet. precompiler exits & Oracle call interface?

Last Answer : By using the statement EXECIAFGET & EXECIAFPUT.

Description : What are the built-ins used for Getting cell values?

Last Answer : GET_GROUP_CHAR_CELL (function) GET_GROUPCELL(function) GET_GROUP_NUMBET_CELL(function)

Description : What are the built-in used for getting cell values?

Last Answer : Get_group_char_cell(function) Get_groupcell(function) Get_group_number_cell(function)

Description : CROSS VALIDATING VALUES

Last Answer : - For key flexfields with multiple segments, we can define rules to cross check value combinations entered with in the key flexfield segments. This option is referred as Cross Validation rules.

Description : A Column is having many repeated values which type of index you should create on this column, if you have to?

Last Answer : For example, assume there is a motor vehicle database with numerous low-cardinality columns such as car_color, car_make, car_model, and car_year. Each column contains less than 100 distinct values by themselves, and a b tree index would be fairly useless in a database of 20 million vehicles.

Description : What are the Referential actions supported by FOREIGN KEY integrity constraint ?

Last Answer : UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Description : Can you pass data parameters to forms?

Last Answer : No

Description : What is the best way to get fro JFK to upper west side manhatten (73rd and Broadway)?

Last Answer : answer:Someone asked the same question a while back and there were some really good answers: http://www.ask-public.com/disc/264/how-do-i-get-from-jfk-airport-to-the-upper-west/ Personally, my preferred ... a lot longer. Which is fine if you have an iPhone to check ask-public while in transit ;)

Description : What are petrochemicals ? Name any two products made fro. n pet rot hemicals. -Geography

Last Answer : Petrochemicals are mainly chemicals derived from petroleum resources like coal, gas and petroleum. Two products are plastics and acrylic fibres.

Description : I soar without wings, I see without eyes. I've traveled the universe to and fro. I've conquered the world, yet I've never been anywhere but home.Who am I? -Riddles

Last Answer : I'm your imagination.

Description : The distance moved and the magnitude of displacement are equal in ? (a) The earth is revolving around the Sun (b) Object moving in circular path (c) The pendulum is moving to and fro (d) Object moving on straight road -Science

Last Answer : (d) only. Distance and displacement in all other cases

Description : looking fro best price for low beam headlamp for lincoln sig. 2005

Last Answer : Need Answer

Description : Assertion (A) `:` Replication and transcription occur in the nucleus but translation occurs in the cytoplasm. Reason (R ) `:` m-RNA is transferred fro

Last Answer : Assertion (A) `:` Replication and transcription occur in the nucleus but translation occurs in the ... D. If both assertion and reason are false.

Description : The comple `[Fe(H_(2)O)_(6)NO]^(2+)` is formed in the brown ring test fro nitrates when freshly prepared `FesO_(4)` solution is added to aqueous solut

Last Answer : The comple `[Fe(H_(2)O)_(6)NO]^(2+)` is formed in the brown ring test fro nitrates when ... electrons is Fe. D. All the above are correct statement.

Description : What expression can be used fro estimating 868 divided by 28?

Last Answer : 31

Description : In a a scientist carries out a series tests that are identical in every respect except fro one factor which is the manipulated variable?

Last Answer : Feel Free to Answer

Description : How long dose it take to get fro Nassau to coco cay on a ship?

Last Answer : Feel Free to Answer

Description : In the book the Indian and the cupboard what are the vocabulary words fro chapter 1?

Last Answer : What is the answer ?

Description : What is acrostic fro delicious?

Last Answer : Need answer

Description : What provisions were included in the articles fro a federal government?

Last Answer : Need answer

Description : How is a physical change different fro a chemical change?

Last Answer : During a physical change the chemical composition is not changed.

Description : do you know where Ican get clean fro phyciatric meds that will kill me and cost me my 24 year sobrietu lorasipan seroquel and depocote?

Last Answer : Lifestream Behavioral Center is a Psychiatric Hospital & Detox Unit: Leesburg, FL - (352) 315-7800

Description : A long thread suspended from a fixed point has a small mass swinging to and fro at its lower end. Then, 1. the potential energy of the mass is minimum in the middle of the swing 2. the kinetic energy is maximum in the middle of ... /are correct? (a) 1 only (b) 1 and 2 (c) 2 and 4 (d) 1, 2, 3 and 4

Last Answer : Ans:(b)

Description : One complete to and fro motion of the particle about its mean position is called

Last Answer : oscillation.

Description : During electrolysis of water, what gas is evolved fro the cathode?

Last Answer : ANSWER: HYDROGEN

Description :  Name the gelatin-like substance which is prepared fro various species of red algae growing in Asiatic waters. The prepared product appears in the form of cakes, coarse granules, long ... or in combination with various nutritive substances, as a medium for culturing bacteria and various fungi  

Last Answer : ANSWER: Agar-agar or just Agar

Description : Ravi walks to and fro to a Gym. He spends 30 minutes in gym. If he walks at speed of 20 km an hour, he returns to home at 8.00 a.m. If he walks at 30 km an hour, he returns to home at 7.30 a.m. How fast must he walk in order to return at 7.15 hours? a) 40 km/hr b) 30 km/hr c) 60 km/hr d) 50 km/hr

Last Answer :  A As per the question, let D be the total distance and ‘t’ is the time taken. So we have: D=20t 20t =30(t-0.5) 20t=30t-15 10t=15 t=3/2 D= 30 km Now, for the condition given we have: 30=S(t-3/4) 30=S(3/2-3/4) 30=S((6-3)/4) 30=S(3/4) S=40 km/hr

Description : Use the add_group_column function to add a column to record group that was created at a design time?

Last Answer : False

Description : What is the function of Optimizer ?

Last Answer : The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.

Description : What is the function of redo log?

Last Answer : The primary function of the redo log is to record all changes made to data.

Description : How is mapping of name of DLL and function done?

Last Answer : The dll can be created using the Visual C++ / Visual Basic Tools and then the dll is put in the path that is defined the registery.

Description : Use the ADD_GROUP_COLUMN function to add a column to a record group that was created at design time? I) TRUE II)FALSE

Last Answer : II) FALSE

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

Description : What is syntax for dropping a procedure and a function .Are these operations possible?

Last Answer : Drop Procedure procedure_name Drop Function function_name

Description : Difference between procedure and function.?

Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

Description : What is difference between a PROCEDURE & FUNCTION ?

Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.

Description : Give the structure of the function ?

Last Answer : FUNCTION name (argument list .....) Return datatype is local variable declarations Begin executable statements Exception execution handlers End;

Description : What is the built-in function used for finding the alert?

Last Answer : Find_alert Editors

Description : Identify package function from the following ?

Last Answer : 1. Error- Code 2. Break 3. Call 4. Error-text 5. Form-failure 6. Form-fatal 7. Execute-query 8. Anchor View 9. Message_code? 1. Error_Code 2. Error_Text 3. Form_Failure 4. Form_Fatal 5. Message_Code

Description : What is the difference between a Function Key Trigger and Key Function Trigger ?

Last Answer : Function key triggers are associated with individual SQL*FORMS function keys You can attach Key function triggers to 10 keys or key sequences that normally do not perform any SQL * FORMS operations. These keys referred as key F0 through key F9.

Description : What are the built-ins used for finding Object ID function?

Last Answer : FIND_GROUP(function) FIND_COLUMN(function)

Description : With which function of summary item is the compute at options required?

Last Answer : ummary item is the compute at options required?