Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Mike

Pages: 1 ... 120 121 [122] 123 124 ... 126
1816
PSOUG / Oracle Advanced Security Encrypts Oracle Applications Data
« on: June 29, 2009, 07:46:57 AM »
Oracle Applications Now Certified with Oracle Advanced Security’s Transparent Data Encryption Feature

Redwood Shores, CA – June 29, 2009

News Facts
Continuing to deliver comprehensive data protection to the Oracleฎ E-Business Suite, Oracle’s PeopleSoft Enterprise, Oracle’s Siebel CRM and Oracle’s JD Edwards EnterpriseOne application customers, Oracle today announced that Oracle Advanced Security, an option to Oracle Database 11g Enterprise Edition, transparently encrypts all application data stored in an Oracle Database tablespace.

Customers that use the Transparent Data Encryption feature of Oracle Advanced Security can now encrypt entire data sets used by Oracle Applications for data privacy protection and to help meet regulatory requirements.

By transparently encrypting application data using Oracle Advanced Security, customers can deploy quickly and implement greater data protection across their applications using efficient transparent encryption and decryption inside their Oracle Database.

Full Encryption for Sensitive Oracle Application Data
Oracle’s Transparent Data Encryption provides increased protection for application data stored in the database (tablespace), without requiring enterprises to know which fields contain sensitive or regulated data, helping reduce deployment time and effort.

It enables strong data privacy through the use of standards-based encryption algorithms such as Advanced Encryption Standard (AES) and Triple Data Encryption Standard (3DES), as well as built-in key management with support for industry leading Hardware Security Modules.

Since Oracle’s Transparent Data Encryption automatically performs all cryptographic operations inside the Oracle Database, no costly and time consuming changes to existing applications are required.

Customers can secure their application data with confidence, knowing the tablespace encryption and decryption operations are performed transparently and efficiently at the Oracle Database I/O layer.

Oracle Advanced Security also works with Oracle Advanced Compression enabling Oracle Database 11g customers to encrypt application data after compression -- providing both data protection and storage savings.

By encrypting data at rest in the database as well as when it leaves the database over the network or during backups, Oracle Advanced Security provides a cost-effective solution for data in transit and at rest encryption.

Part of Oracle's comprehensive portfolio of database security solutions, Oracle Advanced Security helps organizations comply with privacy and regulatory mandates such as Payment Card Industry (PCI) Data Security Standard (DSS), Sarbanes-Oxley (SOX), Health Insurance Portability and Accountability Act (HIPAA) as well as numerous breach notification laws.
Supporting Quotes

“Oracle Applications drive many of the business processes in the enterprise and their data must be protected. Being able to efficiently and transparently encrypt application data in the database tablespace makes Transparent Data Encryption very easy to deploy,” said Vipin Samar, vice president of Database Security, Oracle. “Using the Transparent Data Encryption feature of Oracle Advanced Security in conjunction with Oracle Database 11g, customers can now efficiently encrypt not just select fields or columns, but all the application data - enabling a greater level of data privacy protection.”

“New data privacy regulations are being introduced worldwide and existing regulations are being expanded to address increased threats to data,” said Gary Loveland, PricewaterhouseCoopers' Advisory principal and security practice leader in the US. “Over the years, we've seen requirements to expand protection around critical data such as medical data, personal identifiable information, and credit card information. There is no doubt that in 2010 even more data will need to be protected. Being able to encrypt all application data efficiently is a big benefit to organizations in terms of keeping up with business needs and staying ahead of regulatory requirements.”

Supporting Resources
Oracle Applications
Oracle Advanced Security
Oracle Transparent Data Encryption Best Practices
Oracle E-Business Suite Technology Blog
Oracle Security Inside Out Blog
Download a free, evaluation version of Oracle Database 11g. Terms, conditions and restrictions apply.

For more than 30 years, Oracle has led the industry in securing sensitive data. Oracle Database 11g addresses today’s data security challenges from data encryption, access control, and data classification, to audit and compliance reporting, as well as secure deployments and data masking. The comprehensive portfolio of security options for Oracle Database 11g, including Oracle Advanced Security, Oracle Database Vault, Oracle Label Security, Oracle Data Masking, and Oracle Audit Vault, helps organizations to transparently safeguard against data breaches and to achieve regulatory compliance without requiring changes to existing applications. To learn more about how to protect data with Oracle Database 11g today, please visit: http://www.oracle.com/database/security.

About Oracle
Oracle (NASDAQ: ORCL) is the world's largest business software company. For more information about Oracle, please visit our Web site at http://www.oracle.com.
Trademarks
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Trademarks
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names maybe trademarks of their respective owners.

Contact Info
Eloy Ontiveros
Oracle
+1.650.607.6458
eloy.ontiveros@oracle.com
Kristin Reeves
Blanc & Otus for Oracle
+1.415.856.5145
kreeves@bando.com

1817
PSOUG / U.S. government seeks more data on Oracle-Sun deal
« on: June 29, 2009, 07:38:32 AM »
U.S. government seeks more data on Oracle-Sun deal

U.S. antitrust regulators have asked for more information on Oracle Corp's plan to buy Sun Microsystems Inc and need a little more time to review the $7 billion deal, an attorney for Oracle said.

This means that Oracle has failed to get approval for the deal as quickly as some had hoped, as Friday had marked the expiration of an initial 30-day review period in which antitrust officials could have approved the deal quickly by letting the deadline pass without asking any questions.

The Department of Justice asked both companies for information related to the licensing of Sun's Java software language, said Daniel Wall, a partner with Latham & Watkins and an attorney for Oracle.

The request was related to a narrow, technical matter, according to Wall, who said he expected the DOJ to soon approve the deal and allow Oracle to complete the acquisition during its current fiscal quarter, which ends on August 31.

"We've had a very good dialogue with the Department of Justice and we were almost able to resolve everything before the Second Request deadline. All that's left is one narrow issue about the way rights to Java are licensed that is never going to get in the way of the deal," Wall said in an interview. "I fully expect that the investigation will end soon and not delay the closing of the deal this summer."

Full Story: http://www.reuters.com/article/americasDealsNews/idUSTRE55P6N520090626

1818
PSOUG / Oracle profit beats forecast, margin at record
« on: June 23, 2009, 07:00:18 PM »
Oracle profit beats forecast, margin at record
By Jim Finkle

BOSTON, June 23 (Reuters) - Oracle Corp (ORCL.O) reported quarterly earnings above expectations as the No. 3 software maker's profit margin hit a record thanks to robust growth in its maintenance business, sending shares up 2.7 percent.

The company run by billionaire Larry Ellison also reported a smaller-than-expected drop in new software sales and said it grabbed market share from SAP in certain segments -- signs that Oracle may be weathering the downturn better than rivals.

 "We've been able to push through the economic situation rather well and I have to tell you that I still see the pipeline growing rather significantly," Oracle President Safra Catz said in a conference call.

Oracle's quarterly results and outlook beat expectations it set in March, when executives warned the recession and strong dollar would take a substantial bite out of profits. Since then, the economy has stabilized and the currency has weakened, setting Oracle up to beat those conservative estimates.

Full Story: http://www.reuters.com/article/earningsSeason/idUSN2251761020090623

1819
PSOUG / The NWOUG Fall Conference: September 15th, 2009
« on: June 23, 2009, 07:50:01 AM »
The NWOUG Fall Conference!
September 15th, 2009
Lloyd Center Double Tree Hotel
1000 NE Multnomah Street, Portland, Oregon 97232
503-281-6111
Mark Sunday, Oracle CIO,will be the Keynote Speaker

This exciting conference will bring the best of Oracle innovation and leadership to the Pacific Northwest!

Presenters who wish to be considered for the Fall Conference must submit a 50 - 75word abstract of their presentation to chair@nwoug.org.The time line and steps for presentation submittal, selection and preparation is as follows:

  •   presentation abstract submission opens NOW!
  •   presentation abstract submission closes: June 15, 2009
  •   presentation abstract selection results communicated: June 26, 2009
  •   full presentation due for conference package preparation: August 31,  2009
  •   presentation at the conference: September 15, 2009

   
Additional information regarding the Fall Conference will soon become available here on the NWOUG web sit.

Need more information or have questions? Contact us at chair@nwoug.org.

1820
PSOUG / NoCOUG's First Annual SQL Challenge
« on: June 23, 2009, 07:46:03 AM »
 
FREE Oracle Technology Day - June 17, 2009
NoCOUG's First Annual SQL Challenge

The Northern California Oracle Users Group is an independent, volunteer organization dedicated to the education and representation of the users of Oracle Corporation's database and tools  software. NoCOUG has been around for over 15 years.
      
We are a dynamic group of over 450 members from all over Northern California. Typically from 200 to 250 members and guests attend our meetings each quarter. NoCOUG events take place at various locations around San Francisco Bay, including Redwood Shores, San Ramon, and Sunnyvale. Many of the presentations from our recent conferences are available for download.

We have some terrific, long-term meeting site sponsors as well as vendors who help support our organization.

NoCOUG and the Independent Oracle Users Group (IOUG) are alliance partners. We encourage you to learn more about IOUG by visiting the IOUG website at http://www.ioug.org.

1821
PSOUG / Microsoft kills Visual Studio's Oracle data connection
« on: June 22, 2009, 09:10:30 AM »
Microsoft kills Visual Studio's Oracle data connection
By Gavin Clarke

Swift reaction: 'Sucks', 'shortsighted'

Full Story:
http://www.theregister.co.uk/2009/06/18/microsoft_kills_oracle_connector/

Coders have reacted with disappointment and frustration to Microsoft's decision to cease development of a connector to Oracle in its .NET Framework, a move that looks like another budget cut.

Microsoft has said it will no longer develop OracleClient,or System.Data.OracleClient, with the up-coming .NET Framework 4.0. It will still be included with the framework but will be "marked as deprecated."

The .NET Framework 4.0 is the basis of Visual Studio 2010 - both due later this year - and therefore the programming model for new and recent versions of Windows. Oracle is the industry's number-one database in terms market share.

"We strongly recommend customers to use our partners' ADO.NET Provider for Oracle instead of continuing to use Microsoft's OracleClient for new application development," ADO.NET OracleClient program manager Himanshu Vasishth blogged. He added Microsoft would continue to provide bug fixes for "critical" issues in OracleClient and development of new applications using OracleClient would be supported.

. . .

Furthermore, there's a suggestion that Microsoft is killing its development efforts as part of the overall corporate strategy of cutting costs to get through the recession. Microsoft has been re-configuring product teams and cut projects and business units that are considered small and non-core but that, naturally, have a financial cost associated with them.

Full Story:
http://www.theregister.co.uk/2009/06/18/microsoft_kills_oracle_connector/

1822
PSOUG / Oracle Kills Virtual Iron
« on: June 20, 2009, 08:29:32 PM »
 Oracle is killing off the products of Virtual Iron, a month after purchasing the company. Reports say that all but 10 to 15 staff were let go. The Reg article speculates that Oracle bought VI for its technology and considers its customers and partners expendable. When the Sun purchase finalizes, Oracle will be in possession of three separate virtualization technologies all based on Xen.

Ina letter to Virtual Iron's sales partners, Oracle says it 'will suspend development of existing Virtual Iron products and will suspend delivery of orders to new customers.' One partner said, 'So basically, anyone that built their hosting infrastructure on VI... is now totally in the ****".

1823
PSOUG / Oracle Crystal Ball
« on: June 17, 2009, 01:06:52 PM »
Track the progress of your Financials with accurate forecasting by Oracle Crystal Ball.

Crystal Ball Seminar and Networking Lunch,
Wednesday, July 1, 2009

Register here by creating an Oracle Account

Simulation and optimization techniques can provide critical insight into risk-analysis and decision-making (such as cost estimating, scheduling, resource allocation, engineering design, tolerance allocation, cycle-time reduction, financial/portfolio analysis, sales forecasting, etc.) by modeling the behavior of a process, product or service. This session will demonstrate the benefits of spreadsheet simulation and optimization for business decision-making in a highly uncertain economic environment.

Discussion topics will include:

  • Monte Carlo Simulation 101: What is it and why is it important?
  • How to predict and mitigate the effects of uncertainty and risk.
  • Examples of simulation/optimization applied in business decision analysis.

Through a series of discussion and examples, you will learn practical techniques for how to:

  • Predict performance of current business processes to determine areas of significant improvement potential.
  • Enable rapid analysis in situations with either extensive data OR with no data.
  • Start simple, focus on what’s important. Understand which key factors have the highest impact on your results and where to focus your improvement efforts.

Develop and predict the performance of future-state business initiatives prior to committing to change.

Presented by Fred Ciochetto, Solution Specialist, MBB Oracle Crystal Ball and Greg Nolder, Risk Analysis Consultant for Vose Consulting

Wednesday, July 1, 2009
12:30 p.m. – 2:30 p.m.

Seattle Sheraton Hotel
Jefferson Room
1400 6th Avenue
Seattle, WA 98101

Register for the Crystal Ball Seminar here
  Or Call 1.800.633.0947

1824
PSOUG / Re: How to get Visitors online
« on: June 16, 2009, 09:10:44 AM »
Steve,

We record each unique IP adddress that visits us and store it in a table along with a time and date stamp.

On each page load we do a count of the addresses in the table to get that number.

Also on each page load any IP addresses that are more than 10 minutes old are flushed so they don't get counted. The number you see is the number of different visitors in the last ten minutes.

If you'd like the code for this function, I've pasted a similar function in below.


I go to http://www.psoug.org/library.html

near the bottom there is

  ###  visitors online

How do you get the number of Visitors online ?

Code: [Select]
This script displays number of users currently browsing your site.

The table structure:

CREATE TABLE useronline (
timestamp int(15) DEFAULT '0' NOT NULL,
ip varchar(40) NOT NULL,
file varchar(100) NOT NULL,
PRIMARY KEY (timestamp),
KEY ip (ip),
KEY file (file)
);


The actual Users Online script below should be included in the
footer (or on all pages). It will display the numbers of users
on your website at any one time.

<?php
$server 
"xxx";
$db_user "xxx";
$db_pass "xxx";
$database "xxx";

$db mysql_connect($server$db_user,$db_pass);
mysql_select_db($database,$db);

$timeoutseconds 600//10 minutes

$timestamp time();
$timeout $timestamp-$timeoutseconds;

$insert mysql_query("INSERT INTO useronline VALUES ('$timestamp','$REMOTE_ADDR','$PHP_SELF')",$db);
if(!(
$insert)) &#123;
print "Useronline Insert Failed > ";
&
#125;
$delete mysql_query("DELETE FROM useronline WHERE timestamp<$timeout",$db);
if(!(
$delete)) &#123;
print "Useronline Delete Failed > ";
&
#125;
$result mysql_query("SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'",$db);
if(!(
$result)) &#123;
print "Useronline Select Error > ";
&
#125;
$user mysql_num_rows($result);


mysql_close();
if(
$user == 1) &#123;
print("$user user online\n");
&
#125; else &#123;
print("$user users online\n");
&
#125;
?>

1825
PSOUG / Oracle Development Tools User Group (ODTUG)
« on: June 16, 2009, 05:02:03 AM »
Monterey, CA, June 16, 2009 -- Oracle Development Tools User Group (ODTUG) combines keynotes, technical sessions and hands-on training to make this a must attend technical conference.

WHO:
BI Consulting Group, Oracle’s premier partner for Oracle Business Intelligence.

WHAT:
Doug Burke from BICG will be conducting the an educational workshop covering OBIEE Answers+ on Essbase. Workshop scheduled for Monday, June 22nd from 1pm - 2pm.

Topic of this session will cover OBIEE Answers+ on Essbase: The Future of Ad-Hoc Analysis.

Back in the old days before the Oracle acquisition of Hyperion, you probably used Hyperion Web Analysis as your default front-end on top of Essbase cubes. In the modern world of 2009, there's a better solution: OBIEE Answers+ sitting directly on Essbase. Answers is more robust, feature-rich, and frankly more powerful than Web Analysis ever dreamed of being. In this session, you'll learn how to use Answers on Essbase, leaving Web Analysis behind as you stay on the forefront of cutting edge ad-hoc analysis.

WHEN:
June 21-25, 2009

WHERE:
Hyatt Regency in Monterey, CA, USA

ABOUT BI Consulting Group:
BI Consulting Group is Oracle's premier consulting partner focused exclusively on Oracle Business Intelligence. Service offerings include consulting services, support, and education. The experts at BI Consulting Group have successfully completed some of the most complex implementations of Oracle BI in the world. Along the way, BICG has been honored with Oracle's Most Valuable Partner Award for Business Intelligence and the Oracle Excellence Award for creatively using Oracle Fusion Middleware with Oracle Applications (E-Business Suite, PeopleSoft, Siebel, JD Edwards etc) to create innovative and standards-based technology solutions. www.biconsultinggroup.com.

ABOUT ODTUG
ODTUG is an independent, not-for-profit global organization providing education, support, advocacy, and networking opportunities for all developers, using a variety of technologies, who work on Oracle Databases. ODTUG’s members design applications, model data, write code, manage application systems, maintain legacy code, and are key to the middle-tier technology in Oracle Fusion. For more information visit www.odtug.com

Contact:
Jeremiah Johnson
BI Consulting Group
Monterey, CA
651-403-6527
jeremiah.johnson@biconsultinggroup.com
http://www.biconsultinggroup.com

1826
PSOUG / NWOUG - Lunch & Learn Oracle Hyperion Overview
« on: June 15, 2009, 09:10:37 PM »
NWOUG - Lunch & Learn Oracle Hyperion Overview

Please come lunch and learn about Oracle Hyperion. Oracle Corporation and your Northwest Oracle Users Group (NWOUG) are sponsoring this FREE event -- lunch is included!

Oracle’s Hyperion Enterprise is a proven packaged application that improves departmental financial consolidation and reporting efficiency by streamlining the collection, consolidation, and reporting of financial results in a global environment. With Hyperion Enterprise, you will be able to reduce your financial close cycle, improve the quality of financial information, and enhance decision-making. Hyperion Enterprise can be distributed and installed at remote offices quickly and easily, and can be fully deployed by the finance organization with minimal information technology support.

Jeff Jacoby from Oracle will be the speaker at this event.

Jeff will be sharing with us at this event

ท  Overview of Hyperion

ท  Hyperion strategy/roadmap

ท  Q&A session will follow after the presentation

 
When: Tuesday, Jul 14, 2009, 12:00 PM until 1:30 PM
Where: Oregon Health & Science University (OHSU) STE 900-901
1515 SW 5th Ave.
Portland, OR  97201


Registration is required. Click on the following link to register now, space is limited.

https://nwoug.clubexpress.com/content.aspx?page_id=87&club_id=165905&item_id=93082

1827
PSOUG / Oracle Beware - Google Tests Cloud-Based Database
« on: June 12, 2009, 03:30:21 PM »
Oracle Beware — Google Tests Cloud-Based Database

On Tuesday, the same day Google held a press event to launch its Google Apps Sync for Microsoft Outlook, the company quietly announced in its research team blog a new online database called Fusion Tables.

Under the hood of Fusion Tables is data-spaces technology, which would 'allow Google to add to the conventional two-dimensional database tables a third coordinate with elements like product reviews, blog posts, Twitter messages and the like, as well as a fourth dimension of real-time updates,' according to Stephen E. Arnold, a technology and financial analyst.

'So now we have an n-cube, a four-dimensional space, and in that space we can now do new kinds of queries which create new kinds of products and new market opportunities,' said Arnold, whose research about this topic includes a study done for IDC last August. 'If you're IBM, Microsoft and Oracle, your worst nightmare is now visible.'"

1828
PSOUG / Oracle OpenWorld: October 11th ~ 15th
« on: June 12, 2009, 06:31:23 AM »
Oracle OpenWorld: October 11th ~ 15th

Where can you find the most relevant content for your business and technology needs, network with peers from around the world, get hands-on experience with a full breadth of Oracle technology, and preview what’s coming next from Oracle and its partners? At Oracle OpenWorld,  October 11th ~ 15th.

Oracle OpenWorld brings you more than 1,800 sessions, 400 partner exhibits, keynotes from the world’s technology leaders, hands-on labs, several special networking events, and more. In one place, with one purpose: to help you get the most business benefit from your technology, today and in the future. Learn. Plan. Profit. It all starts here.

Oracle OpenWorld Highlights
    Hotel and Travel Information
    Registration Details
    Session Streams and Tracks
    Oracle Develop
    Primavera Program

   Oracle Mix
    Oracle OpenWorld Blog
    Oracle OpenWorld Wiki
    Exhibition Experience
    Sponsor Listing

   Exhibition Hall Floor Plans
    Oracle PartnerNetwork Activities
    Win a ride with Sean Tucker
    Why Attend Oracle OpenWorld


1829
PSOUG / Re: Add Columns to big Oracle table
« on: June 02, 2009, 08:32:46 PM »
That's a lot of rows to add columns to. Frankly I'd be surprised if it didn't take a while.   :)

Maybe someone here can suggest some tips to speed it up, but I think what you're seeing may be normal.


Hi All,
   I am adding 6 null columns to big oracle table with about 60 million records and it is taking forever to complete.  Any suggestions?  Thanks…Sam 

1830
PSOUG / By Request: How to send email from Oracle
« on: June 02, 2009, 08:51:49 AM »
We've had numerous requests asking how to send email from Oracle....here's one way:

Code: [Select]
create or replace procedure E_MAIL(

p_to in varchar2,
p_from in varchar2,
p_subject in varchar2,
p_text in varchar2 default null,
p_html in varchar2 default null,
p_smtp_hostname in varchar2,
p_smtp_portnum in varchar2)
is
l_boundary varchar2(255) default ‘a1b2c3d4e3f2g1′;
l_connection utl_smtp.connection;
l_body_html clob := empty_clob; –This LOB will be the email message
l_offset number;
l_ammount number;
l_temp varchar2(32767) default null;
begin
l_connection := utl_smtp.open_connection( p_smtp_hostname, p_smtp_portnum );
utl_smtp.helo( l_connection, p_smtp_hostname );
utl_smtp.mail( l_connection, p_from );
utl_smtp.rcpt( l_connection, p_to );

l_temp := l_temp || ‘MIME-Version: 1.0′ || chr(13) || chr(10);
l_temp := l_temp || ‘To: ‘ || p_to || chr(13) || chr(10);
l_temp := l_temp || ‘From: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Subject: ‘ || p_subject || chr(13) || chr(10);
l_temp := l_temp || ‘Reply-To: ‘ || p_from || chr(13) || chr(10);
l_temp := l_temp || ‘Content-Type: multipart/alternative; boundary=’ ||
chr(34) || l_boundary || chr(34) || chr(13) ||
chr(10)||utl_tcp.CRLF;

—————————————————-
– Write the headers
dbms_lob.createtemporary( l_body_html, false, 10 );
dbms_lob.write(l_body_html,length(l_temp),1,l_temp);

—————————————————-
– Write the text boundary
l_offset := dbms_lob.getlength(l_body_html) + 1;
l_temp := ‘–’ || l_boundary || chr(13)||chr(10);
l_temp := l_temp || ‘content-type: text/plain; charset=us-ascii’ ||
chr(13) || chr(10) || chr(13) || chr(10);
dbms_lob.write(l_body_html,length(l_temp),l_offset,l_temp);

—————————————————-
– Write the plain text portion of the email
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.write(l_body_html,length(p_text),l_offset,p_text);

—————————————————-
– Write the HTML boundary
l_temp := chr(13)||chr(10)||chr(13)||chr(10)||’–’ || l_boundary ||
chr(13) || chr(10);
l_temp := l_temp || ‘content-type: text/html;’ ||
chr(13) || chr(10) || chr(13) || chr(10);
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.write(l_body_html,length(l_temp),l_offset,l_temp);

—————————————————-
– Write the HTML portion of the message
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.write(l_body_html,length(p_html),l_offset,p_html);

—————————————————-
– Write the final html boundary
l_temp := chr(13) || chr(10) || ‘–’ || l_boundary || ‘–’ || chr(13);
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.write(l_body_html,length(l_temp),l_offset,l_temp);

—————————————————-
– Send the email in 1900 byte chunks to UTL_SMTP
l_offset := 1;
l_ammount := 1900;
utl_smtp.open_data(l_connection);
while l_offset < dbms_lob.getlength(l_body_html) loop
utl_smtp.write_data(l_connection,
dbms_lob.substr(l_body_html,l_ammount,l_offset));
l_offset := l_offset + l_ammount ;
l_ammount := least(1900,dbms_lob.getlength(l_body_html) – l_ammount);
end loop;
utl_smtp.close_data(l_connection);
utl_smtp.quit( l_connection );
dbms_lob.freetemporary(l_body_html);
end;


After creating this procedure, just call it from any form or trigger.

Pages: 1 ... 120 121 [122] 123 124 ... 126