Category Archives: Oracle

PL/SQL for Sending Email with Mandrill API :: Oracle UTL_SMTP with Authentication

CREATE OR REPLACE PR OCEDURE p_send_mail ( p_sender_name IN VARCHAR2, p_sender IN VARCHAR2, p_recipient IN VARCHAR2, p_subject IN VARCHAR2, –p_cc IN VARCHAR2, p_message IN VARCHAR2) IS conn UTL_SMTP.CONNECTION; crlf VARCHAR2(2) := CHR(13) || CHR(10); — Mandrill Login Details uname VARCHAR2(200) := ‘[email protected]’; EmailServer VARCHAR2(60) := ‘smtp.mandrillapp.com’; pwd VARCHAR2(200) := ‘mandrillappkey’; p_port VARCHAR2(10) := ’25’; –… Read More »

Create New Schema in Oracle 11G express

In order to create a new schema in oracle 11G express, we need to create a user account and assign all the privileges. Step 1 : Open SQL command Line Step 2 : Run Connect Step 3 : Enter Username : SYSTEM Step 4 : Enter Password for The SYSTEM account , which is specified… Read More »

Installing Oracle OCI (oci8) library to Lubuntu 10.04.4 LTS – Using OCI instantclient 12.1

First Check Version of your Ubuntu Run Command :  lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 10.04.4 LTS Release: 10.04 Codename: lucid Pre Requisites: sudo apt-get install build-essential sudo apt-get install php5-dev php-pear libaio1 Instant Client installation requires some environment variables to be able to see the library folder. Edit /etc/environment and add at the… Read More »

First MVC ODP.net project using entity framework – Part 2/2

Task : Connect to oracle DB using ODP.net and generate forms using Entity Frame Work without any coding. Pre Requisites : Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio  http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html Microsoft Visual Studio 2013 Oracle Database Instance Credentials. Entity Framework 6 Tools for Visual Studio 2012 & 2013 (http://www.microsoft.com/en-us/download/details.aspx?id=40762) Oracle Database… Read More »

Create and Manage Oracle Database Using Oracle SQL Developer GUI

Pre Requisites: Oracle SQL Developer Oracle Database Instance Login Details Complete Video Tutorial Step 1: Install Oracle SQL Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Please note that in order to install Developer Tool you must have JDK 7 or above in your PC. If you do not have please download JDK from following link prior to downloading to SQL… Read More »