Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Package | Package AS_XLSX | Next Package |
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 |