Objects and Arguments for Package AS_XLSX
Object Name Overload Argument Name Position Datatype Direction
CELL 1 P_COL 1 BINARY_INTEGER IN
CELL 1 P_ROW 2 BINARY_INTEGER IN
CELL 1 P_VALUE 3 NUMBER IN
CELL 1 P_NUMFMTID 4 BINARY_INTEGER IN
CELL 1 P_FONTID 5 BINARY_INTEGER IN
CELL 1 P_FILLID 6 BINARY_INTEGER IN
CELL 1 P_BORDERID 7 BINARY_INTEGER IN
CELL 1 P_ALIGNMENT 8 PL/SQL RECORD IN
CELL 1 P_SHEET 9 BINARY_INTEGER IN
CELL 2 P_COL 1 BINARY_INTEGER IN
CELL 2 P_ROW 2 BINARY_INTEGER IN
CELL 2 P_VALUE 3 VARCHAR2 IN
CELL 2 P_NUMFMTID 4 BINARY_INTEGER IN
CELL 2 P_FONTID 5 BINARY_INTEGER IN
CELL 2 P_FILLID 6 BINARY_INTEGER IN
CELL 2 P_BORDERID 7 BINARY_INTEGER IN
CELL 2 P_ALIGNMENT 8 PL/SQL RECORD IN
CELL 2 P_SHEET 9 BINARY_INTEGER IN
CELL 3 P_COL 1 BINARY_INTEGER IN
CELL 3 P_ROW 2 BINARY_INTEGER IN
CELL 3 P_VALUE 3 DATE IN
CELL 3 P_NUMFMTID 4 BINARY_INTEGER IN
CELL 3 P_FONTID 5 BINARY_INTEGER IN
CELL 3 P_FILLID 6 BINARY_INTEGER IN
CELL 3 P_BORDERID 7 BINARY_INTEGER IN
CELL 3 P_ALIGNMENT 8 PL/SQL RECORD IN
CELL 3 P_SHEET 9 BINARY_INTEGER IN
CLEAR_WORKBOOK          
COMMENT   P_COL 1 BINARY_INTEGER IN
COMMENT   P_ROW 2 BINARY_INTEGER IN
COMMENT   P_TEXT 3 VARCHAR2 IN
COMMENT   P_AUTHOR 4 VARCHAR2 IN
COMMENT   P_WIDTH 5 BINARY_INTEGER IN
COMMENT   P_HEIGHT 6 BINARY_INTEGER IN
COMMENT   P_SHEET 7 BINARY_INTEGER IN
DEFINED_NAME   P_TL_COL 1 BINARY_INTEGER IN
DEFINED_NAME   P_TL_ROW 2 BINARY_INTEGER IN
DEFINED_NAME   P_BR_COL 3 BINARY_INTEGER IN
DEFINED_NAME   P_BR_ROW 4 BINARY_INTEGER IN
DEFINED_NAME   P_NAME 5 VARCHAR2 IN
DEFINED_NAME   P_SHEET 6 BINARY_INTEGER IN
DEFINED_NAME   P_LOCALSHEET 7 BINARY_INTEGER IN
FINISH   <return value for function>   BLOB OUT
FREEZE_COLS   P_NR_COLS 1 BINARY_INTEGER IN
FREEZE_COLS   P_SHEET 2 BINARY_INTEGER IN
FREEZE_ROWS   P_NR_ROWS 1 BINARY_INTEGER IN
FREEZE_ROWS   P_SHEET 2 BINARY_INTEGER IN
GET_ALIGNMENT   P_VERTICAL 1 VARCHAR2 IN
GET_ALIGNMENT   P_HORIZONTAL 2 VARCHAR2 IN
GET_ALIGNMENT   P_WRAPTEXT 3 PL/SQL BOOLEAN IN
GET_ALIGNMENT   <return value for function>   PL/SQL RECORD OUT
GET_BORDER   P_TOP 1 VARCHAR2 IN
GET_BORDER   P_BOTTOM 2 VARCHAR2 IN
GET_BORDER   P_LEFT 3 VARCHAR2 IN
GET_BORDER   P_RIGHT 4 VARCHAR2 IN
GET_BORDER   <return value for function>   BINARY_INTEGER OUT
GET_EXCEL_FROM_SQL   P_SQL 1 VARCHAR2 IN
GET_EXCEL_FROM_SQL   P_COLUMN_HEADERS 2 PL/SQL BOOLEAN IN
GET_EXCEL_FROM_SQL   P_DIRECTORY 3 VARCHAR2 IN
GET_EXCEL_FROM_SQL   P_FILENAME 4 VARCHAR2 IN
GET_EXCEL_FROM_SQL   P_SHEET 5 BINARY_INTEGER IN
GET_EXCEL_FROM_SQL   <return value for function>   BLOB OUT
GET_FILL   P_PATTERNTYPE 1 VARCHAR2 IN
GET_FILL   P_FGRGB 2 VARCHAR2 IN
GET_FILL   <return value for function>   BINARY_INTEGER OUT
GET_FONT   P_NAME 1 VARCHAR2 IN
GET_FONT   P_FAMILY 2 BINARY_INTEGER IN
GET_FONT   P_FONTSIZE 3 NUMBER IN
GET_FONT   P_THEME 4 BINARY_INTEGER IN
GET_FONT   P_UNDERLINE 5 PL/SQL BOOLEAN IN
GET_FONT   P_ITALIC 6 PL/SQL BOOLEAN IN
GET_FONT   P_BOLD 7 PL/SQL BOOLEAN IN
GET_FONT   P_RGB 8 VARCHAR2 IN
GET_FONT   <return value for function>   BINARY_INTEGER OUT
GET_NUMFMT   P_FORMAT 1 VARCHAR2 IN
GET_NUMFMT   <return value for function>   BINARY_INTEGER OUT
HYPERLINK   P_COL 1 BINARY_INTEGER IN
HYPERLINK   P_ROW 2 BINARY_INTEGER IN
HYPERLINK   P_URL 3 VARCHAR2 IN
HYPERLINK   P_VALUE 4 VARCHAR2 IN
HYPERLINK   P_SHEET 5 BINARY_INTEGER IN
LIST_VALIDATION 1 P_SQREF_COL 1 BINARY_INTEGER IN
LIST_VALIDATION 1 P_SQREF_ROW 2 BINARY_INTEGER IN
LIST_VALIDATION 1 P_TL_COL 3 BINARY_INTEGER IN
LIST_VALIDATION 1 P_TL_ROW 4 BINARY_INTEGER IN
LIST_VALIDATION 1 P_BR_COL 5 BINARY_INTEGER IN
LIST_VALIDATION 1 P_BR_ROW 6 BINARY_INTEGER IN
LIST_VALIDATION 1 P_STYLE 7 VARCHAR2 IN
LIST_VALIDATION 1 P_TITLE 8 VARCHAR2 IN
LIST_VALIDATION 1 P_PROMPT 9 VARCHAR2 IN
LIST_VALIDATION 1 P_SHOW_ERROR 10 PL/SQL BOOLEAN IN
LIST_VALIDATION 1 P_ERROR_TITLE 11 VARCHAR2 IN
LIST_VALIDATION 1 P_ERROR_TXT 12 VARCHAR2 IN
LIST_VALIDATION 1 P_SHEET 13 BINARY_INTEGER IN
LIST_VALIDATION 2 P_SQREF_COL 1 BINARY_INTEGER IN
LIST_VALIDATION 2 P_SQREF_ROW 2 BINARY_INTEGER IN
LIST_VALIDATION 2 P_DEFINED_NAME 3 VARCHAR2 IN
LIST_VALIDATION 2 P_STYLE 4 VARCHAR2 IN
LIST_VALIDATION 2 P_TITLE 5 VARCHAR2 IN
LIST_VALIDATION 2 P_PROMPT 6 VARCHAR2 IN
LIST_VALIDATION 2 P_SHOW_ERROR 7 PL/SQL BOOLEAN IN
LIST_VALIDATION 2 P_ERROR_TITLE 8 VARCHAR2 IN
LIST_VALIDATION 2 P_ERROR_TXT 9 VARCHAR2 IN
LIST_VALIDATION 2 P_SHEET 10 BINARY_INTEGER IN
MERGECELLS   P_TL_COL 1 BINARY_INTEGER IN
MERGECELLS   P_TL_ROW 2 BINARY_INTEGER IN
MERGECELLS   P_BR_COL 3 BINARY_INTEGER IN
MERGECELLS   P_BR_ROW 4 BINARY_INTEGER IN
MERGECELLS   P_SHEET 5 BINARY_INTEGER IN
NEW_SHEET   P_SHEETNAME 1 VARCHAR2 IN
ORAFMT2EXCEL   P_FORMAT 1 VARCHAR2 IN
ORAFMT2EXCEL   <return value for function>   VARCHAR2 OUT
QUERY2SHEET   P_SQL 1 VARCHAR2 IN
QUERY2SHEET   P_COLUMN_HEADERS 2 PL/SQL BOOLEAN IN
QUERY2SHEET   P_DIRECTORY 3 VARCHAR2 IN
QUERY2SHEET   P_FILENAME 4 VARCHAR2 IN
QUERY2SHEET   P_SHEET 5 BINARY_INTEGER IN
SAVE   P_DIRECTORY 1 VARCHAR2 IN
SAVE   P_FILENAME 2 VARCHAR2 IN
SET_AUTOFILTER   P_COLUMN_START 1 BINARY_INTEGER IN
SET_AUTOFILTER   P_COLUMN_END 2 BINARY_INTEGER IN
SET_AUTOFILTER   P_ROW_START 3 BINARY_INTEGER IN
SET_AUTOFILTER   P_ROW_END 4 BINARY_INTEGER IN
SET_AUTOFILTER   P_SHEET 5 BINARY_INTEGER IN
SET_COLUMN   P_COL 1 BINARY_INTEGER IN
SET_COLUMN   P_NUMFMTID 2 BINARY_INTEGER IN
SET_COLUMN   P_FONTID 3 BINARY_INTEGER IN
SET_COLUMN   P_FILLID 4 BINARY_INTEGER IN
SET_COLUMN   P_BORDERID 5 BINARY_INTEGER IN
SET_COLUMN   P_ALIGNMENT 6 PL/SQL RECORD IN
SET_COLUMN   P_SHEET 7 BINARY_INTEGER IN
SET_COLUMN_WIDTH   P_COL 1 BINARY_INTEGER IN
SET_COLUMN_WIDTH   P_WIDTH 2 NUMBER IN
SET_COLUMN_WIDTH   P_SHEET 3 BINARY_INTEGER IN
SET_ROW   P_ROW 1 BINARY_INTEGER IN
SET_ROW   P_NUMFMTID 2 BINARY_INTEGER IN
SET_ROW   P_FONTID 3 BINARY_INTEGER IN
SET_ROW   P_FILLID 4 BINARY_INTEGER IN
SET_ROW   P_BORDERID 5 BINARY_INTEGER IN
SET_ROW   P_ALIGNMENT 6 PL/SQL RECORD IN
SET_ROW   P_SHEET 7 BINARY_INTEGER IN