How to call oracle database stored procedure from form in
form coding ?
Answers were Sorted based on User's Feedback
Answer / ashwinee
It can be called directly in triggers or program units
provided the form schema has grants for the stored
procedures.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / j.c
1. After Store procedure registration using the submit
request i can call database procedure.
2. Using Oracle Alert I can also call oracle database store
procedure.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / m,n
up to my knowledge i have written into the WEB.SHOW_DOCUMENT
()
Forms module, the following code can be used in a WHEN-
BUTTON-PRESSED trigger to execute a Report that has a
parameter form:
or
and report:RUN_REPORT_OBJECT('name')..
| Is This Answer Correct ? | 3 Yes | 7 No |
Can you have two stored functions with in the same name?
what type of testing u r doing?
where u do setup of operating unit?
what are version control tools used in oracle apps?
what is the back ground program run while transferring data from OM to AR?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
Is it possible to do purchase order without requisition?
what is the error you will get if field is referenced in wrong repeating frame?
What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter
where we find the status of order information.
What are different execution methods of executabls?
What is the maximum number of statements that can be specified in a trigger statement?