Skip to content

Instantly share code, notes, and snippets.

View divitoDBA's full-sized avatar

divitoDBA

View GitHub Profile
@divitoDBA
divitoDBA / gist:24a287962eff8ba1e4b74d38efaeae69
Created July 11, 2017 22:12
PHP 5.6.31 and OCI8 2.0.12 - expected output
[root@server bin]# ./pecl install oci8-2.0.12
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update
downloading oci8-2.0.12.tar ...
Starting to download oci8-2.0.12.tar (1,615,360 bytes)
.............................................................................................................................. .............................................................................................................................. ..................................................................done: 1,615,360 bytes
11 source files, building
running: phpize
Configuring for:
PHP Api Version: 20131106
Zend Module Api No: 20131226
@divitoDBA
divitoDBA / 0_reuse_code.js
Created January 24, 2017 18:31
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@divitoDBA
divitoDBA / gist:e14342cd2ec112cb98558ba5dadd3af5
Last active February 14, 2019 13:02
Sample PL/SQL procedure to send HTML as mail text
CREATE OR REPLACE PROCEDURE PLMAIL
is
l_mail_conn UTL_SMTP.connection;
l_boundary VARCHAR2(50) := '----=*#abc1234321cba#*=';
l_step PLS_INTEGER := 12000;
p_to varchar2(100) default 'to@mail.com' ;
p_from varchar2(100) default 'from@mail.com' ;
p_subject varchar2(200) default 'sample pl/sql using html as mail text' ;
function getData(){
var jqhxr = $.ajax({
type: 'GET',
url: 'https://<-my REST endpoint->',
"async": true,
"crossDomain": true,
dataType: 'json',
"headers": {
"x-apikey": "<-my API key->",
"content-type": "application/json" }
@divitoDBA
divitoDBA / create_invoice.json
Created November 26, 2015 14:41
QuickBooks create invoice JSON API - V3 QBO
{
"Line": [
{
"Amount": 100.00,
"DetailType": "SalesItemLineDetail",
"SalesItemLineDetail": {
"ItemRef": {
"value": "1",
"name": "Services"
}