dgsoft/alexandria-plsql-utils
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
106 Commits 1 Branch 0 Tags
Commit Graph

60 Commits

Author SHA1 Message Date
mortenbra
c8f024b50d
Merge pull request #60 from datRedHeadedGuy/get_worksheets_list-returns-sheets-in-order-of-creation-#44 
Update ora/ooxml_util_pkg.pkb to fix #44
 2019-09-22 10:23:35 +02:00
mortenbra
6acaf5c440
Merge pull request #58 from eaolson/issue57 
Fix issue 57, put clean_string back
 2019-09-22 10:22:05 +02:00
Morten Braten
7e63ae2dad Option to specify status when creating iCalendar event 2019-01-14 18:48:02 +01:00
Morten Braten
b485b5bd72 Enhanced iCalendar protocol support 2019-01-14 18:10:28 +01:00
datRedHeadedGuy
da26641236 Update ora/ooxml_util_pkg.pks 
Forgot the change to the package specifications when the 'state' attribute was added to t_xlsx_sheet_properties.
 2018-10-11 16:40:20 -05:00
datRedHeadedGuy
9b0738037b Update ora/ooxml_util_pkg.pkb 
Modified the ooxml_util_pkg and added a 'state' attribute to t_xlsx_sheet_properties and removed the ORDER BY clause.
 2018-10-11 16:11:43 -05:00
eaolson
9680b0e7ea Fix issue 57, put clean_string back 2018-10-07 10:18:22 -05:00
Morten Braten
c121c58480 Merge branch 'master' of github.com:mortenbra/alexandria-plsql-utils 2018-10-03 20:04:16 +02:00
Morten Braten
1b4c1cb0ab Enhancements to web_util_pkg 2018-10-03 20:03:07 +02:00
mortenbra
8a46dc2719
Merge pull request #56 from eaolson/issue28 
Fix for issue 28
 2018-06-18 08:29:31 +02:00
mortenbra
0fab97d188
Merge pull request #55 from eaolson/issue52 
Fix for issue 52
 2018-06-18 08:27:48 +02:00
eaolson
af005d4e06 Fix issue 28 
Raise error if cannot be converted to XML.
 2018-06-17 14:53:47 -05:00
eaolson
30cc22719b Fix issue52 
xlsx_builder_pkg will be invoker rights
 2018-06-17 14:26:12 -05:00
eaolson
8b7488fa5b Fix issue 35 2018-06-17 14:12:54 -05:00
eaolson
ae0bbbf11c Add to_char 2018-06-17 13:53:58 -05:00
Morten Braten
48807a2ad5 Slack utility package 2018-02-20 11:51:16 +01:00
datRedHeadedGuy
c0fcb8ac5f Renamed return values. 
Renamed the return values 'l_returnvalue' for the functions ooxml_util_pkg.get_xlsx_column_number() and ooxml_util_pkg.get_xlsx_column_ref().
 2016-12-06 09:59:14 -06:00
datRedHeadedGuy
33aeca0f20 Modified ooxml_util_pkg functions 
Modified the ooxml_util_pkg.get_xlsx_column_ref and the
ooxml_util_pkg.get_xlsx_column_number functions to support columns up to
the limit (currently XFD or 16384) and in
ooxml_util_pkg.get_xlsx_column_ref to fix the bug where the '@' is
returned at multiples of 26.
 2016-12-01 21:54:50 -06:00
krissco
48cfe3ae40 New s3 API for get_object_list 
Updated get_object_list private procedure to use new S3 API which performs MUCH better on large buckets. I also changed a for-loop to a bulk-collect.
 2016-10-06 12:16:23 -07:00
Morten Braten
953efe5166 Added PayPal REST API package 2016-08-13 17:06:43 +02:00
eaolson
bb233608a1 Move demos to demos\xlsx_builder_pkg_demo.sql 2016-08-05 19:46:17 -05:00
eaolson
b5806145f2 Update "as_xlsx" in examples to match new package name 2016-07-23 17:04:57 -05:00
eaolson
24af12697a Update to version dated 2013-08-27 
From
https://technology.amis.nl/wp-content/uploads/2011/02/as_xlsx11.txt.
Changed name from as_xlsx. Updated examples at the end of the .pks file
to match.
 2016-07-23 17:01:18 -05:00
tompetrus
ae8f2d2058 Bugfix add1xml 
When the length of p_xml would be an exact multitude of 4000 the loop
over chunks would execute one time too much, causing "ORA-06502: PLSQL:
numeric of value error: invalid LOB locator specified: ORA-22275",
because the second part of dbms_lob.append would be NULL. A check is
added on the length of the clob and if if the mod of 4000 is zero, we
decrease the amount of loops by one.
 2016-05-20 16:29:56 +02:00
David Gale
2583ce7127 Update ooxml_util_pkg.pkb 
Added the ability for get_file_from_template to update the notes of a PowerPoint slide in addition to the content.
 2016-05-03 12:14:16 -04:00
mortenbra
4c5d9a3b8c Merge pull request #22 from eaolson/get_item_parse 
Parse Id and ChangeKey as attributes
 2016-04-21 11:33:56 +02:00
Eric Olson
7785c334d1 Fix Id attribute in a few other places 2016-04-20 18:51:11 -05:00
Tim Nanos
e46bb1c3bd Function is_valid_email2() was returned for the backward compatibility 2016-04-04 17:59:53 +03:00
Tim Nanos
e618894a6a Function is_valid_email2() was returned for the backward compatibility 2016-04-04 17:56:16 +03:00
Tim Nanos
3e8c6b0f10 Email validation was changed to follow RFC 5322 standard 
The email regexp was improved to be case-insensitive.
Old is_valid_email() function was removed.
is_valid_email2() function was renamed to is_valid_email() in order to
be more user-friendly.
Code readability was improved.
 2016-04-01 14:48:25 +03:00
datRedHeadedGuy
f671dd16eb Update ooxml_util_pkg.pks 
Added a new function within the ooxml_util_pkg specifications that will return a collection of the worksheet records that include the name of the worksheet, the sheet ID of the worksheet, and the relationship ID for the worksheet. This will allow for the ability to look-up worksheets and parse them without needing to know what the worksheet's name is in advance.
 2016-03-04 16:24:00 -06:00
datRedHeadedGuy
18985e2c12 Update ooxml_util_pkg.pkb 
Added a new function within the ooxml_util_pkg body that will return a collection of the worksheet records that include the name of the worksheet, the sheet ID of the worksheet, and the relationship ID for the worksheet. This will allow for the ability to look-up worksheets and parse them without needing to know what the worksheet's name is in advance.
 2016-03-04 16:18:44 -06:00
Eric Olson
3c63b278d0 Change XPath for get_item 
Id and ChangeKey are attributes.
 2016-01-04 18:54:56 -06:00
Morten Braten
04214e0844 Added concat_array function 2015-11-25 18:23:05 +01:00
Morten Braten
b557efce4c Added add_token procedure 2015-10-30 14:24:15 +01:00
Morten Braten
2213e3df2f Added SMS utility package 2015-09-24 19:09:35 +02:00
Morten Braten
5254680126 Added get_date_tab to generate table of dates 2015-09-24 19:08:17 +02:00
Morten Braten
d2e71075ef Fix for empty parameter name 2015-09-24 19:06:03 +02:00
mortenbra
957c4ad6e8 Merge pull request #16 from eaolson/xlsx_formatted_text 
Fixes issue #6
 2015-05-25 13:11:52 +02:00
Eric Olson
3643767bbc Get all <t> nodes under <si> 
Change XPath query to get all <t> nodes under the <si> node of interest,
regardless of their depth. This concatenates the resulting text() nodes
together.
 2015-05-24 10:30:15 -05:00
mortenbra
f2779cae60 Merge pull request #15 from mjhasbach/string_util_pkg.is_str_alpha 
Added string_util_pkg.is_str_alpha
 2015-05-16 12:28:35 +02:00
Matthew Hasbach
5b576cfa0c Resolved merge conflict due to is_str_alpha and is_str_alphanumeric being similarly named 2015-05-15 14:29:36 -04:00
mortenbra
6fb3de351e Merge pull request #14 from mjhasbach/string_util_pkg.is_str_integer 
Added string_util_pkg.is_str_integer
 2015-05-15 13:11:11 +02:00
Matthew Hasbach
8fdac96e66 Added string_util_pkg.is_str_integer 2015-05-14 14:31:36 -04:00
mortenbra
cb58d29a9a Merge pull request #13 from mjhasbach/Improve_string_util_pkg.str_to_bool_str 
Improved string_util_pkg.str_to_bool_str
 2015-05-14 00:24:07 +02:00
Matthew Hasbach
8e4a27db73 Added string_util_pkg.is_str_alpha 2015-05-13 18:00:45 -04:00
Matthew Hasbach
01f129e2a5 Added string_util_pkg.is_str_alphanumeric 2015-05-13 17:49:01 -04:00
Matthew Hasbach
d3af944d27 string_util_pkg.str_to_bool_str now leverages string_util_pkg.str_to_bool in order to reduce code redundancy 2015-05-13 17:26:07 -04:00
Brett Roper
2f3ef811c9 remove invalid low end ascii. see: http://support.microsoft.com/kb/315580 2015-05-10 12:43:55 +08:00
mortenbra
62755ea4bf Merge pull request #8 from JesperLorentzen/patch-1 
Performance was real bad for convert clob to CSV
 2015-04-26 22:47:17 +02:00