Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
In Data set can I write a Procedural SQL like below to call the package spec parameters?? Please confirm... DECLARE P_BOARD_NAME VARCHAR2(200); P_INCIDENT_NAME VARCHAR2(200); P_START_DATE DATE; P_END_DATE DATE; p_Cursor SYS_REFCURSOR; P_TOTAL_INCIDENTS NUMBER; P_DISTRICT VARCHAR2(200); P_ROUTES_OPEN NUMBER;…
-
Thank you for your reply!!! I have created below the Package and have the steps to add the event trigger. can you tell me what type of SQL have to execute and how to pass the parameter in the data set. create or replace PACKAGE PKG_RPT_EXECUTIVE_SUMMARY AS PROCEDURE RPT_EXECV_SUMRY_CURRENTSTATUS ( p_board_name IN varchar2,…
-
Thank you very much for the detailed information! Can you please give me the syntax/example how the parameters are passed in data set. I'm actually creating the report using package first time.. all your inputs are valuable for me.
-
Thanks for your reply Youssef!!! below is the error I'm getting when I try to generate the xml. [171115_12320012][DATA PROCESSOR ID:309002466][SCH JOB INFO:]Bind Variables ... [171115_12320012][DATA PROCESSOR ID:309002466][SCH JOB INFO:] 1: pv_board:Hurricane [171115_12320012][DATA PROCESSOR ID:309002466][SCH JOB…
-
Thank you for your reply...