ORACLE® FORMS DEVELOPER GRAPHICS BUILDER REFERENCE
CHART BUILT-INS OG_DELETE_COLUMN OG_DELETE_FIELD OG_GET_CHART_ELEMENT OG_GET_COLUMN OG_GET_FIELD OG_GET_ROW OG_INSERT_FIELD OG_MAKE_CHART OG_UPDATE_CHART DATABASE BUILT-INS OG_CONNECT OG_LOGGED_ON OG_LOGOFF OG_LOGON DISPLAY BUILT-INS OG_CLOSE_DISPLAY OG_GENERATE_DISPLAY OG_GET_DISPLAY OG_ISNULL OG_OPEN_DISPLAY OG_SAVE_DISPLAY GRAPHIC OBJECT BUILT-INS OG_CLONE (OBJECT) OG_DAMAGE (OBJECT) OG_DELETE_CHILD OG_DELETE_CMPTEXT OG_DELETE_POINT OG_DELETE_PROPERTY OG_DELETE_SMPTEXT OG_DESTROY (OBJECT) OG_DRAW OG_EXPORT_DRAWING (DISPLAY) OG_EXPORT_DRAWING (OBJECT/LAYER) OG_EXPORT_DRAWING (WINDOW) OG_EXPORT_IMAGE OG_GET_CHAR_PROPERTY OG_GET_CHILD OG_GET_CMPTEXT OG_GET_DATE_PROPERTY OG_GET_NUM_PROPERTY OG_GET_OBJECT OG_GET_POINT OG_GET_SMPTEXT OG_IMPORT_DRAWING OG_IMPORT_IMAGE OG_INSERT_CHILD OG_INSERT_CMPTEXT OG_INSERT_POINT OG_INSERT_SMPTEXT OG_MAKE_ELLIPSE OG_MAKE_GROUP OG_MAKE_IMAGE OG_MAKE_LINE OG_MAKE_POLY OG_MAKE_RECT OG_MAKE_RRECT OG_MAKE_SYMBOL OG_MAKE_TEXT OG_MOVE OG_POINT_IN OG_POINT_NEAR OG_PROPERTY_EXISTS OG_ROTATE OG_SAME OG_SCALE OG_SET_EDGECOLOR OG_SET_FILLCOLOR OG_SET_PROPERTY OG_SYNCHRONIZE OG_UPDATE_BBOX LAYER BUILT-INS OG_ACTIVATE_LAYER OG_GET_LAYER OG_HIDE_LAYER OG_SHOW_LAYER MISCELLANEOUS BUILT-INS DO_SQL OG_APPEND_DIRECTORY OG_APPEND_FILE OG_CENTER OG_DAMAGE (REGION) OG_GET_ATTR (APPLICATION) OG_GET_ATTR (AXIS) OG_GET_ATTR (DISPLAY) OG_GET_ATTR (FIELD TEMPLATE) OG_GET_ATTR (FRAME TEMPLATE) OG_GET_ATTR (OBJECT) OG_GET_ATTR (PRINTER) OG_GET_ATTR (QUERY) OG_GET_ATTR (REFERENCE LINE) OG_GET_ATTR (SOUND) OG_GET_ATTR (TIMER) OG_GET_ATTR (WINDOW) OG_GET_BUTTONPROC OG_HELP OG_HOST OG_PAUSE OG_PRINT OG_QUIT OG_ROOT_OBJECT OG_SET_ATTR (APPLICATION) OG_SET_ATTR (AXIS) OG_SET_ATTR (CHART ELEMENT) OG_SET_ATTR (DISPLAY) OG_SET_ATTR (FIELD TEMPLATE) OG_SET_ATTR (FRAME TEMPLATE) OG_SET_ATTR (OBJECT) OG_SET_ATTR (PRINTER) OG_SET_ATTR (QUERY) OG_SET_ATTR (REFERENCE LINE) OG_SET_ATTR (SOUND) OG_SET_ATTR (TIMER) OG_SET_ATTR (WINDOW) OG_TRANSLATE_ENVVAR OG_USER_EXIT PARAMETER BUILT-INS OG_DELETE_PARAM OG_GET_CHAR_PARAM OG_GET_DATE_PARAM OG_GET_NUM_PARAM OG_GET_PARAM_TYPE OG_PARAM_EXISTS OG_SET_PARAM QUERY BUILT-INS OG_APPEND_ROW OG_CLEAR_QUERY OG_DATA_CHANGED OG_DATA_QUERIED OG_DESTROY (QUERY) OG_EXECUTE_QUERY OG_GET_CHARCELL OG_GET_DATECELL OG_GET_NEWROWS OG_GET_NUMCELL OG_GET_QUERY OG_GET_SCHEMA OG_INSERT_COLUMN OG_MAKE_QUERY OG_NEXT_ROW OG_NUMCOLS OG_NUMROWS OG_SET_CHARCELL OG_SET_DATECELL OG_SET_NUMCELL OG_SET_SCHEMA OG_START_FROM SOUND BUILT-INS OG_DESTROY (SOUND) OG_EXPORT_SOUND OG_GET_SOUND OG_IMPORT_SOUND OG_MAKE_SOUND OG_PLAY_SOUND OG_RECORD_SOUND OG_STOP_SOUND TEMPLATE BUILT-INS OG_CLONE (TEMPLATE) OG_DELETE_FTEMP OG_DELETE_REFLINE OG_DESTROY (TEMPLATE) OG_EXPORT_TEMPLATE OG_GET_AXIS OG_GET_FTEMP OG_GET_REFLINE OG_GET_TEMPLATE OG_IMPORT_TEMPLATE OG_INSERT_FTEMP OG_INSERT_REFLINE OG_MAKE_TEMPLATE TIMER BUILT-INS OG_ACTIVATE_TIMER OG_DEACTIVATE_TIMER OG_DESTROY (TIMER) OG_GET_TIMER OG_MAKE_TIMER TOOLS_INT BUILT-INS TOOL_INT ADD_PARAMETER TOOL_INT CREATE_PARAMETER_LIST TOOL_INT DELETE_PARAMETER TOOL_INT DESTROY_PARAMETER_LIST TOOL_INT GET_PARAMETER_ATTR TOOL_INT GET_PARAMETER_LIST TOOL_INT ISNULL TOOL_INT RUN_PRODUCT TOOL_INT SET_PARAMETER_ATTR WINDOW BUILT-INS OG_DESTROY (WINDOW) OG_GET_WINDOW OG_HIDE_WINDOW OG_MAKE_WINDOW OG_SHOW_WINDOW PROPERTIES APPLICATION PROPERTIES CONNECTION STRING PROPERTY CURSOR PROPERTY HORIZONTAL LAYOUT RESOLUTION PROPERTY HORIZONTAL SCREEN RESOLUTION PROPERTY PASSWORD PROPERTY PLATFORM PROPERTY USERNAME PROPERTY VERTICAL LAYOUT RESOLUTION PROPERTY VERTICAL SCREEN RESOLUTION PROPERTY ARC PROPERTIES BASE ARC PROPERTY CLOSURE PROPERTY FILL PROPERTY AXIS (DATE) PROPERTIES AUTO MAXIMUM PROPERTY AUTO MINIMUM PROPERTY AUTO STEP PROPERTY CUSTOM FORMAT PROPERTY DAY FORMAT PROPERTY FIRST MONTH PROPERTY LABELS PROPERTY MAXIMUM PROPERTY MINIMUM PROPERTY MONTH FORMAT PROPERTY QUARTER FORMAT PROPERTY SKIP WEEKENDS PROPERTY STEP PROPERTY YEAR FORMAT PROPERTY AXIS (GENERIC) PROPERTIES AXIS LABEL PROPERTY AXIS TYPE PROPERTY CUSTOM LABEL PROPERTY DIRECTION PROPERTY MAJOR GRID PROPERTY MAJOR TICKS PROPERTY MINOR GRID PROPERTY MINOR TICKS PROPERTY MINOR TICKS PER INTERVAL PROPERTY POSITION PROPERTY TICK LABEL ROTATION PROPERTY TICK LABELS PROPERTY TICK POSITION PROPERTY AXIS (DISCRETE) PROPERTIES DATE FORMAT PROPERTY MAXIMUM NUMBER OF CATEGORIES PROPERTY MINIMUM NUMBER OF CATEGORIES PROPERTY NUMBER FORMAT PROPERTY AXIS (CONTINUOUS) PROPERTIES PERCENT BY PROPERTY PERCENT OF PROPERTY SCALE PROPERTY CHART ELEMENT PROPERTIES BUTTON PROCEDURE PROPERTY EVENTS PROPERTY EXPLOSION PROPERTY NAME PROPERTY CHART PROPERTIES AUTO UPDATE PROPERTY END ROW PROPERTY FILTER PROPERTY QUERY PROPERTY RANGE PROPERTY SIZE AND POSITION PROPERTY START ROW PROPERTY TEMPLATE PROPERTY TITLE PROPERTY COMPOUND TEXT PROPERTIES SIMPLE TEXT COUNT PROPERTY DISPLAY PROPERTIES CLOSE TRIGGER PROPERTY HEIGHT PROPERTY OPEN TRIGGER PROPERTY WIDTH PROPERTY FRAME (AXIS CHART) PROPERTIES BASELINE AXIS PROPERTY BASELINE VALUE PROPERTY CATEGORY WIDTH PROPERTY CUSTOM DATE FORMAT PROPERTY CUSTOM NUMBER FORMAT PROPERTY REFERENCE LINE COUNT PROPERTY SECOND Y AXIS PROPERTY FRAME (GENERIC) PROPERTIES DEPTH SIZE PROPERTY FIELD TEMPLATE COUNT PROPERTY FRAME TYPE PROPERTY LEGEND PROPERTY LEGEND COLUMN COUNT PROPERTY PLOT FRAME PROPERTY ROOT PROPERTY SHADOW DIRECTION PROPERTY SHADOW SIZE PROPERTY FRAME (PIE CHART) PROPERTIES CATEGORIES PROPERTY CATEGORY DATE FORMAT PROPERTY CATEGORY NUMBER FORMAT PROPERTY DATA VALUES PROPERTY NO OVERLAP PROPERTY OTHER PROPERTY PERCENT FORMAT PROPERTY PERCENT VALUES PROPERTY PLOT ORDER PROPERTY TICKS PROPERTY USAGE PROPERTY USAGE VALUE PROPERTY VALUE FORMAT PROPERTY FRAME (TABLE CHART) PROPERTIES COLUMN NAMES PROPERTY GRID COUNT PROPERTY HORIZONTAL GRID PROPERTY MAXIMUM NUMBER OF ROWS PROPERTY MINIMUM NUMBER OF ROWS PROPERTY VERTICAL GRID PROPERTY FIELD TEMPLATE (GENERIC) PROPERTIES COLOR ROTATION PROPERTY FIELD TEMPLATE (AXIS CHART) PROPERTIES AXIS PROPERTY CURVE FIT PROPERTY LABEL ROTATION PROPERTY LINE STYLE PROPERTY OVERLAP PROPERTY PLOT POSITION PROPERTY PLOT TYPE PROPERTY GENERIC PROPERTIES COLUMN PROPERTY EXECUTE QUERY PROPERTY FORMAT TRIGGER PROPERTY HIDE OBJECT PROPERTY INNER BOUNDING BOX PROPERTY OBJECT TYPE PROPERTY OUTER BOUNDING BOX PROPERTY PARENT PROPERTY SET PARAMETER PROPERTY GRAPHIC PROPERTIES BACKGROUND EDGE COLOR PROPERTY BACKGROUND FILL COLOR PROPERTY BEVEL STYLE PROPERTY CAP STYLE PROPERTY DASH STYLE PROPERTY EDGE PATTERN PROPERTY EDGE WIDTH PROPERTY FILL PATTERN PROPERTY FOREGROUND EDGE COLOR PROPERTY FOREGROUND FILL COLOR PROPERTY JOIN STYLE PROPERTY ROTATION ANGLE PROPERTY TRANSFER MODE PROPERTY GROUP PROPERTIES CHILD COUNT PROPERTY CLIP FLAG PROPERTY IMAGE PROPERTIES CLIP RECTANGLE PROPERTY DITHER PROPERTY QUALITY PROPERTY LINE PROPERTIES ARROW STYLE PROPERTY END POINT PROPERTY START POINT PROPERTY POLYGON PROPERTIES POINT COUNT PROPERTY PRINTER PROPERTIES PROPERTY COPIES PROPERTY END PAGE PROPERTY LANDSCAPE PROPERTY PAGE SIZE PROPERTY PRINT FILE PROPERTY START PAGE PROPERTY QUERY PROPERTIES CACHE TYPE PROPERTY CUSTOM QUERY PROCEDURE PROPERTY EXECUTE ON OPEN PROPERTY EXECUTE ON TIMER PROPERTY MAXIMUM ROWS PROPERTY MAXIMUM ROWS FLAG PROPERTY POST-QUERY TRIGGER PROCEDURE PROPERTY QUERY SOURCE PROPERTY QUERY TYPE PROPERTY RECTANGLE PROPERTIES PROPERTY BASE RECTANGLE PROPERTY REFERENCE LINE PROPERTIES DATE VALUE PROPERTY LABEL PROPERTY NUMBER VALUE PROPERTY ROUNDED RECTANGLE PROPERTIES CORNER RADII PROPERTY SIMPLE TEXT PROPERTIES COLOR PROPERTY FONT PROPERTY TEXT STRING PROPERTY SOUND PROPERTIES PROPERTY SYMBOL PROPERTIES PROPERTY CENTER PROPERTY SYMBOL SIZE PROPERTY TEXT PROPERTIES BOUNDING BOX HEIGHT PROPERTY BOUNDING BOX WIDTH PROPERTY CHARACTER SET PROPERTY COMPOUND TEXT COUNT PROPERTY CUSTOM SPACING PROPERTY FIXED BOUNDING BOX PROPERTY HORIZONTAL ALIGNMENT PROPERTY HORIZONTAL ORIGIN PROPERTY INVISIBLE PROPERTY KERNING PROPERTY NEAREST PROPERTY ORIGIN POINT PROPERTY POINT SIZE PROPERTY SCALABLE BOUNDING BOX PROPERTY SCALABLE FONT PROPERTY SPACING PROPERTY STYLE PROPERTY SYNTHESIZE PROPERTY TYPEFACE PROPERTY VERTICAL ALIGNMENT PROPERTY VERTICAL ORIGIN PROPERTY WEIGHT PROPERTY WRAPAROUND PROPERTY TIMER PROPERTIES ACTIVE PROPERTY INTERVAL PROPERTY PROCEDURE PROPERTY WINDOW PROPERTIES HELP TARGET PROPERTY ATTRIBUTES USING ATTRIBUTE RECORDS OVERVIEW ATTRIBUTE CLASSES COMBINED ATTRIBUTE RECORDS MASK ATTRIBUTES MASK CONSTANTS CREATEABLE, SETABLE, GETABLE ATTRIBUTES SHORTCUT BUILT-INS APPLICATION ATTRIBUTE RECORD ARC COMBINED ATTRIBUTE RECORD ARC ATTRIBUTE RECORD CONTINUOUS AXIS COMBINED ATTRIBUTE RECORD CONTINUOUS AXIS ATTRIBUTE RECORD DATE AXIS COMBINED ATTRIBUTE RECORD DATE AXIS ATTRIBUTE RECORD DISCRETE AXIS COMBINED ATTRIBUTE RECORD DISCRETE AXIS ATTRIBUTE RECORD AXIS ATTRIBUTE RECORD CHART COMBINED ATTRIBUTE RECORD CHART ATTRIBUTE RECORD CHART ELEMENT COMBINED ATTRIBUTE RECORD CHART ELEMENT ATTRIBUTE RECORD DISPLAY ATTRIBUTE RECORD AXIS FIELD TEMPLATE COMBINED ATTRIBUTE RECORD AXIS FIELD TEMPLATE ATTRIBUTE RECORD FIELD TEMPLATE ATTRIBUTE RECORD AXIS FRAME COMBINED ATTRIBUTE RECORD AXIS FRAME ATTRIBUTE RECORD FRAME ATTRIBUTE RECORD PIE FRAME COMBINED ATTRIBUTE RECORD PIE FRAME ATTRIBUTE RECORD TABLE FRAME COMBINED ATTRIBUTE RECORD TABLE FRAME ATTRIBUTE RECORD GENERIC ATTRIBUTE RECORD GRAPHIC COMBINED ATTRIBUTE RECORD GRAPHIC ATTRIBUTE RECORD GROUP COMBINED ATTRIBUTE RECORD GROUP ATTRIBUTE RECORD IMAGE COMBINED ATTRIBUTE RECORD IMAGE ATTRIBUTE RECORD LINE COMBINED ATTRIBUTE RECORD LINE ATTRIBUTE RECORD POLYGON COMBINED ATTRIBUTE RECORD POLYGON ATTRIBUTE RECORD PRINTER ATTRIBUTE RECORD QUERY ATTRIBUTE RECORD RECTANGLE COMBINED ATTRIBUTE RECORD RECTANGLE ATTRIBUTE RECORD REFERENCE LINE ATTRIBUTE RECORD ROUNDED RECTANGLE COMBINED ATTRIBUTE RECORD ROUNDED RECTANGLE ATTRIBUTE RECORD SOUND ATTRIBUTE RECORD SYMBOL COMBINED ATTRIBUTE RECORD SYMBOL ATTRIBUTE RECORD TEXT ATTRIBUTES OVERVIEW TEXT COMBINED ATTRIBUTE RECORD TEXT ATTRIBUTE RECORD FONT ATTRIBUTE RECORD COMPOUND TEXT ELEMENT ATTRIBUTE RECORD SIMPLE TEXT ELEMENT ATTRIBUTE RECORD TIMER ATTRIBUTES WINDOW ATTRIBUTE RECORD GLOBAL VARIABLES BUILT-IN GLOBAL VARIABLES OG_APP OG_INCH OG_NULL_AXIS OG_NULL_BUTTONPROC OG_NULL_DISPLAY OG_NULL_FTEMP OG_NULL_LAYER OG_NULL_OBJECT OG_NULL_QUERY OG_NULL_REFLINE OG_NULL_SOUND OG_NULL_TEMPLATE OG_NULL_TIMER OG_NULL_WINDOW BUILT-IN SUBPROGRAMS CHART BUILT-INS OG_DELETE_COLUMN OG_DELETE_FIELD OG_GET_CHART_ELEMENT OG_GET_COLUMN OG_GET_FIELD OG_GET_ROW OG_INSERT_FIELD OG_MAKE_CHART OG_UPDATE_CHART OG_DELETE_COLUMN DESCRIPTION THIS PROCEDURE DELETES A COLUMN FROM A CUSTOM QUERY SYNTAX PROCEDURE OG_DELETE_COLUMN (QUERY_HDL OG_QUERY, INDX NUMBER, TOTAL NUMBER); PARAMETERS QUERY_HDL IS THE HANDLE TO THE QUERY FROM WHICH TO DELETE THE COLUMN INDX IS THE INDEX OF THE FIRST COLUMN TO DELETE FROM THE QUERY TOTAL IS THE TOTAL NUMBER OF COLUMNS TO DELETE OG_DELETE_COLUMN EXAMPLE /* THE FOLLOWING PROCEDURE DELETES A COLUMN ** FROM THE QUERY ‘QUERY0’: */ PROCEDURE EXAMPLE(COL_NUM NUMBER) IS QUERY OG_QUERY; BEGIN QUERY:=OG_GET_QUERY(‘QUERY0’); OG_DELETE_COLUMN(QUERY, COL_NUM, 1); END; OG_DELETE_FIELD DESCRIPTION THIS PROCEDURE DELETES ONE OR MORE FIELDS FROM THE SPECIFIED CHART OBJECT SYNTAX PROCEDURE OG_DELETE_FIELD (CHART_HDL OG_OBJECT, INDX NUMBER, TOTAL NUMBER); PARAMETERS CHART_HDL IS THE HANDLE TO THE CHART OBJECT INDX IS THE INDEX OF THE FIRST FIELD TO DELETE FROM THE FIELD LIST TOTAL IS THE TOTAL NUMBER OF FIELDS TO DELETE USAGE NOTES DELETING A FIELD ONLY REMOVES IT FROM THE SPECIFIED CHART IT DOES NOT DELETE (OR OTHERWISE MODIFY) THE FIELD TEMPLATE THAT THE FIELD MAY REFERENCE IN ADDITION, ANY CHANGES YOU MAKE TO THE CHART'S FIELD LIST WILL NOT BE APPLIED UNTIL THE CHART IS UPDATED VIA A CALL TO OG_UPDATE_CHART OG_DELETE_FIELD EXAMPLES /* SUPPOSE ONE CHART CURRENTLY DISPLAYS PLOTS FOR BOTH SALARY ** AND COMMISSION DATA, AND YOU WANT TO REMOVE THE ** COMMISSION PLOT FROM THAT CHART AND PLOT IT ON ANOTHER ONE */ PROCEDURE TRANSFER_COMM(CHART1 IN OG_OBJECT, CHART2 IN OG_OBJECT, FIELD_INDEX IN NUMBER) IS THE_FIELD OG_FIELD; BEGIN THE_FIELD:=OG_GET_FIELD(CHART1, FIELD_INDEX); OG_DELETE_FIELD(CHART1, FIELD_INDEX, 1); OG_INSERT_FIELD(CHART2, THE_FIELD, OG_LAST); OG_UPDATE_CHART(CHART1, OG_ALL_CHUPDA); OG_UPDATE_CHART(CHART2, OG_ALL_CHUPDA); END; OG_GET_CHART_ELEMENT DESCRIPTION GIVEN THE HANDLE TO A GROUP OF CHART ELEMENTS (BARS, PIE SLICES, ETC) AND A ROW NUMBER, THIS FUNCTION RETURNS THE INDIVIDUAL ELEMENT CORRESPONDING TO THAT ROW NUMBER SYNTAX FUNCTION OG_GET_CHART_ELEMENT (GROUP_HDL OG_OBJECT, ROW_NUM NUMBER) RETURN OG_OBJECT; PARAMETERS GROUP_HDL IS THE HANDLE TO THE GROUP CONTAINING THE CHART ELEMENT ROW_NUM IS THE ROW NUMBER CORRESPONDING TO THE CHART ELEMENT YOU WISH TO GET RETURNS THE INDIVIDUAL CHART ELEMENT FOR THE SPECIFIED ROW NUMBER USAGE NOTES THE GROUP HANDLE CAN BE RETRIEVED FROM THE CHART OBJECT USING OG_GET_OBJECT WITH THE APPROPRIATE NAME OG_GET_CHART_ELEMENT EXAMPLES /* THE FOLLOWING PROCEDURE CHANGES THE COLOR OF THE FIRST: ** BAR IN A COLUMN CHART, REGARDLESS OF ITS VALUE: */ PROCEDURE EXAMPLE(CHART OG_OBJECT) IS BARS_GROUP OG_OBJECT; ELEM OG_OBJECT; BEGIN BARS_GROUP := OG_GET_OBJECT('SAL_BARS', CHART); ELEM := OG_GET_CHART_ELEMENT(BARS_GROUP, 0); OG_SET_FILLCOLOR(ELEM, 'RED'); END; OG_GET_COLUMN DESCRIPTION THIS FUNCTION RETURNS THE NAME OF THE QUERY COLUMN REPRESENTED BY A SPECIFIC CHART ELEMENT SYNTAX FUNCTION OG_GET_COLUMN (CHELEMENT_HDL OG_OBJECT) RETURN VARCHAR2; PARAMETERS CHELEMENT_HDL IS THE HANDLE TO THE CHART ELEMENT RETURNS THE NAME OF THE COLUMN ASSOCIATED WITH THE CHART ELEMENT OG_GET_COLUMN EXAMPLES /* THE FOLLOWING FUNCTION RETURNS THE QUERY COLUMN REPRESENTED BY ** THE FIRST BAR IN A COLUMN CHART: */ FUNCTION EXAMPLE(CHART OG_OBJECT) RETURN CHAR IS BARS OG_OBJECT; ELEM OG_OBJECT; COL VARCHAR2(15); BEGIN BARS := OG_GET_OBJECT('SAL_BARS', CHART); ELEM := OG_GET_CHART_ELEMENT(BARS, 0); COL := OG_GET_COLUMN(ELEM); RETURN(COL); END; OG_GET_FIELD DESCRIPTION THIS FUNCTION RETURNS A RECORD CONTAINING THE FIELD'S ATTRIBUTE VALUES IN THE SPECIFIED CHART SYNTAX FUNCTION OG_GET_FIELD (CHART_HDL OG_OBJECT, INDX NUMBER) RETURN OG_FIELD; PARAMETERS CHART_HDL IS THE HANDLE TO THE CHART OBJECT INDX IS THE INDEX OF THE FIELD IN THE CHART'S FIELD LIST TO BE RETURNED RETURNS THE ATTRIBUTES OF THE SPECIFIED FIELD OG_GET_FIELD EXAMPLES /* SUPPOSE ONE CHART CURRENTLY DISPLAYS PLOTS FOR BOTH SALARY ** AND COMMISSION DATA, AND YOU WANT TO REMOVE THE ** COMMISSION PLOT FROM THAT CHART AND PLOT IT ON ANOTHER ONE: */ PROCEDURE TRANSFER_COMM(CHART1 IN OG_OBJECT, CHART2 IN OG_OBJECT, FIELD_INDEX IN NUMBER) IS THE_FIELD OG_FIELD BEGIN THE_FIELD:=OG_GET_FIELD(THE_CHART, FIELD_INDEX); OG_DELETE_FIELD(CHART1, FIELD_INDEX, 1); OG_INSERT_FIELD(CHART2, THE_FIELD, OG_LAST); END; OG_GET_ROW DESCRIPTION THIS FUNCTION RETURNS THE QUERY ROW NUMBER THAT IS REPRESENTED BY A SPECIFIC CHART ELEMENT SYNTAX FUNCTION OG_GET_ROW (CHELEMENT_HDL OG_OBJECT, RETURN NUMBER; PARAMETERS CHELEMENT_HDL IS THE HANDLE TO THE CHART ELEMENT RETURNS THE ROW NUMBER ASSOCIATED WITH THE CHART ELEMENT OG_GET_ROW EXAMPLES /* THE FOLLOWING FORMAT TRIGGER EXPLODES THE PIE SLICE ** REPRESENTING SAL FOR EMPLOYEE 'SMITH': */ PROCEDURE OGFORMATTRIG0(ELEM IN OG_OBJECT, QUERY IN OG_QUERY) IS ENAME VARCHAR2(10); CHART OG_OBJECT; ROW_NUM NUMBER; BEGIN ENAME := OG_GET_CHARCELL(QUERY, 'ENAME'); IF ENAME = 'SMITH' THEN CHART := OG_GET_OBJECT('CHART0'); ROW_NUM := OG_GET_ROW(ELEM); OG_SET_EXPLOSION(CHART, ROW_NUM, 'SAL', 25); END IF; END; OG_INSERT_FIELD DESCRIPTION THIS PROCEDURE INSERTS A NEW FIELD INTO THE SPECIFIED CHART SYNTAX PROCEDURE OG_INSERT_FIELD (CHART_HDL OG_OBJECT, FIELD_REC OG_FIELD, INDX NUMBER); PARAMETERS CHART_HDL IS THE HANDLE TO THE CHART OBJECT, FIELD_REC IS THE RECORD CONTAINING THE FIELD'S ATTRIBUTES INDX IS THE INDEX AT WHICH TO INSERT THE NEW FIELD IN THE CHART'S FIELD LIST THIS ARGUMENT MUST BE AN INTEGER BETWEEN 0 AND N (INCLUSIVE), WHERE N IS THE NUMBER OF FIELDS IN THE CHART PRIOR TO THE INSERTION THE VALUE OF THIS ARGUMENT MAY ALSO BE ONE OF THE FOLLOWING BUILT-IN CONSTANTS: OG_FIRST MEANS INSERT THE NEW FIELD AT THE BEGINNING OF THE CHART'S FIELD LIST (INDEX = 0) OG_LAST MEANS INSERT THE NEW FIELD AT THE END OF THE CHART'S FIELD LIST (INDEX = THE NUMBER OF FIELDS IN THE CHART PRIOR TO THE INSERTION) USAGE NOTES ANY CHANGES YOU MAKE TO THE CHART'S FIELD LIST ARE NOT APPLIED UNTIL THE CHART IS UPDATED VIA A CALL TO OG_UPDATE_CHART OG_INSERT_FIELD EXAMPLES /* SUPPOSE ONE CHART CURRENTLY DISPLAYS PLOTS FOR BOTH ** SALARY AND COMMISSION DATA, AND YOU WANT TO REMOVE ** THE COMMISSION PLOT FROM THAT CHART AND PLOT IT ON ANOTHER ONE: */ PROCEDURE TRANSFER_COMM (CHART1 IN OG_OBJECT, CHART2 IN OG_OBJECT, FIELD_INDEX IN NUMBER) IS THE_FIELD OG_FIELD; BEGIN THE_FIELD:=OG_GET_FIELD(THE_CHART, FIELD_INDEX); OG_DELETE_FIELD(CHART1, FIELD_INDEX, 1); OG_INSERT_FIELD(CHART2, THE_FIELD, OG_LAST); END; OG_MAKE_CHART DESCRIPTION THIS FUNCTION CREATES A CHART SYNTAX FUNCTION OG_MAKE_CHART (POSITION OG_POINT, HEIGHT NUMBER, WIDTH NUMBER, TEMPLATE OG_TEMPLATE,