SUBMIT_FEEDBACK Procedure

This procedure enables you to write a procedure to submit feedback, rather than using the page that can be generated by create page of type feedback.

Syntax

APEX_UTIL.SUBMIT_FEEDBACK (
    p_comment          IN VARCHAR2 DEFAULT NULL,
    p_type             IN NUMBER   DEFAULT '1',
    p_application_id   IN VARCHAR2 DEFAULT NULL,
    p_page_id          IN VARCHAR2 DEFAULT NULL,
    p_email            IN VARCHAR2 DEFAULT NULL,
    p_screen_width     IN VARCHAR2 DEFAULT NULL,
    p_screen_height    IN VARCHAR2 DEFAULT NULL,
    p_attribute_01     IN VARCHAR2 DEFAULT NULL,
    p_attribute_02     IN VARCHAR2 DEFAULT NULL,
    p_attribute_03     IN VARCHAR2 DEFAULT NULL,
    p_attribute_04     IN VARCHAR2 DEFAULT NULL,
    p_attribute_05     IN VARCHAR2 DEFAULT NULL,
    p_attribute_06     IN VARCHAR2 DEFAULT NULL,
    p_attribute_07     IN VARCHAR2 DEFAULT NULL,
    p_attribute_08     IN VARCHAR2 DEFAULT NULL,
    p_label_01         IN VARCHAR2 DEFAULT NULL,
    p_label_02         IN VARCHAR2 DEFAULT NULLl,
    p_label_03         IN VARCHAR2 DEFAULT NULL,
    p_label_04         IN VARCHAR2 DEFAULT NULL,
    p_label_05         IN VARCHAR2 DEFAULT NULL,
    p_label_06         IN VARCHAR2 DEFAULT NULL,
    p_label_07         IN VARCHAR2 DEFAULT NULL,
    p_label_08         IN VARCHAR2 DEFAULT NULL);

Parameters

Table 21-103 describes the parameters available in the SUBMIT_FEEDBACK procedure.

Table 21-103 SUBMIT_FEEDBACK Parameters

Parameter	Description
`p_comment`	Comment to be submitted
`p_type`	Type of feedback (1 is General Comment, 2 is Enhancement Request, 3 is Bug)
`p_application_id`	ID of application related to the feedback
`p_page_id`	ID of page related to the feedback
`p_email`	Email of the user providing the feedback
`p_screen_width`	Width of screen at time feedback was provided
`p_screen_height`	Height of screen at time feedback was provided
`p_attribute_01`	Custom attribute for collecting feedback
`p_attribute_02`	Custom attribute for collecting feedback
`p_attribute_03`	Custom attribute for collecting feedback
`p_attribute_04`	Custom attribute for collecting feedback
`p_attribute_05`	Custom attribute for collecting feedback
`p_attribute_06`	Custom attribute for collecting feedback
`p_attribute_07`	Custom attribute for collecting feedback
`p_attribute_08`	Custom attribute for collecting feedback
`p_label_01`	Label for corresponding custom attribute
`p_label_02`	Label for corresponding custom attribute
`p_label_03`	Label for corresponding custom attribute
`p_label_04`	Label for corresponding custom attribute
`p_label_05`	Label for corresponding custom attribute
`p_label_06`	Label for corresponding custom attribute
`p_label_07`	Label for corresponding custom attribute
`p_label_08`	Label for corresponding custom attribute

Example

The following example submits a bug about page 22 within application 283.

begin
    apex_util.submit_feedback (
       p_comment        => 'This page does not render properly for me',
       p_type           => 3,
       p_application_id => 283,
       p_page_id        => 22,
       p_email          => 'user@xyz.corp',
       p_attribute_01   => 'Charting',
       p_label_01       => 'Component' );
end;
/