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 |
where do u specify in org_id?
what is MRC? Why it is needed?
how to debug the report?
2 Answers IBM, Qualcomm, Sierra Atlantica,
wheather discard file is automatically created or explicty created?can u mention it?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
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
How to print multi currency,multi language in xml?
Stored procedure?
There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.
What r the validation done in ap inbound ?
define steps of assigning items to an organization.