Compile for Debugging: Loads debugging information for the selected object.In Database Explorer, right-click the procedure you want to compile, click Compile, and then select one of the following options on the shortcut menu:
To compile the stored procedure for debugging, do the following: Otherwise, dbForge Studio for Oracle prompts you to compile it. Prior to debugging, you should compile the stored procedure for debugging. The pop-up window informing about the successful completion and the execution time appears.
#PL SQL DEVELOPER TEST SCRIPT EXAMPLE MOD#
SCHEDULEID = SCHEDULE_ID - IF (TEMPLATE_ID IS NULL) THEN - RAISE_APPLICATION_ERROR(-20001, 'TEMPLATE_ID IS NULL' ) -ĞND IF SELECT DATE_OUT, DAY_ORDER, GETFIRSTDAYOFMONTH ( DATE_OUT ) BULK COLLECT INTO DAY_ENUM FROM ( SELECT DATE_FROM - 1 + ROWNUM AS DATE_OUT, NVL ( NULLIF ( MOD ( ROWNUM, TEMPLATE_COUNT ), 0 ), TEMPLATE_COUNT ) AS DAY_ORDER FROM ALL_OBJECTS WHERE ROWNUM dialog box, enter input parameters. TEMPLATEID ) INTO TEMPLATE_COUNT, TEMPLATE_ID FROM SCHEDULE. TIME_SHEET_DATE - TIME_SHEET_DATE - DATE ) SELECT COUNT ( * ), MAX ( S. DAY_ORDER - DAY_ORDER - NUMBER(*, 0), DAY_ENUM2. WORK ( DATE_OUT, DAY_ORDER, TIME_SHEET_DATE ) VALUES ( DAY_ENUM2.
FILLSCHEDULE ( DATE_FROM IN DATE, DATE_TO IN DATE, SCHEDULE_ID IN INT ) AS TEMPLATE_COUNT SMALLINT TEMPLATE_ID INT DAY_COUNT INT TYPE REC_TYPE IS RECORD ( DATE_OUT DATE, DAY_ORDER SMALLINT, TIME_SHEET_DATE DATE ) TYPE ENUM_TYPE IS TABLE OF REC_TYPE DAY_ENUM ENUM_TYPE DAY_ENUM2 REC_TYPE1 BEGIN DAY_ENUM2 : = REC_TYPE1 ( DATE_FROM, NULL, SYSDATE ) DAY_ENUM2.
0 kommentar(er)
