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 ... 115 116 [117] 118 119 ... 121
1741
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.

1742
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/

1743
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 ****".

1744
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

1745
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;
?>

1746
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

1747
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

1748
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.'"

1749
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


1750
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 

1751
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.

1752
PSOUG / A neat trick from Denes Kubicek's ApEx BLOG....
« on: June 02, 2009, 08:28:19 AM »
A neat trick from Denes Kubicek's ApEx BLOG....

In Apex you can create links out of your columns in a report. What you currently can't do is to put a condition behind this link and generate it upon that condition - if there is a link then it is there for all the rows. The only workarround for this is to create the link in your SQL. In that case your SQL may look quite clumsy and hard to read. Something like this:

Code: [Select]
SELECT CASE
          WHEN deptno = 10
             THEN    '<a href="java-script:popUp2('''
                  || 'f?p=&APP_ID.:500:&SESSION.::&DEBUG.::'
                  || 'P500_DEPTNO:'
                  || deptno
                  || ''', 700, 700);">'
                  || '<img src="#IMAGE_PREFIX#gobut.gif">'
                  || '</a>'
          WHEN deptno = 20
             THEN    '<a href="java-script:popUp2('''
                  || 'f?p=&APP_ID.:501:&SESSION.::&DEBUG.::'
                  || 'P501_DEPTNO:'
                  || deptno
                  || ''', 700, 700);">'
                  || '<img src="#IMAGE_PREFIX#go_search.gif">'
                  || '</a>'
          ELSE    '<a href="java-script:popUp2('''
               || 'f?p=&APP_ID.:502:&SESSION.::&DEBUG.::'
               || 'P502_DEPTNO:'
               || deptno
               || ''', 700, 700);">'
               || '<img src='
               || '"#WORKSPACE_IMAGES#go_button.gif">'
               || '</a>'
       END LINK,
       ename, job, hiredate
  FROM emp


The solution for this problem you can find here. Back in 2006 I created a function for generating links. This function can do the following for you:

  • create a link based on a target page you provide, without having to code a full apex link,
  • replace the link with an image if desired,
  • sort the links based on any columns in your source,
  • open the target page in the same window or in a popup window,
  • add a request to your link,
  • reset pagination if required,
  • add a checksum to your link.

At the end, your query looks much better if you use that function:

Code: [Select]
SELECT CASE
          WHEN deptno = 10
             THEN return_link_fn (p_page         => 500,
                                  p_item         => 'P500_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'gobut.gif'
                                 )
          WHEN deptno = 20
             THEN return_link_fn (p_page         => 501,
                                  p_item         => 'P501_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'go_search.gif'
                                 )
             ELSE return_link_fn (p_page         => 502,
                                  p_item         => 'P502_DEPTNO',
                                  p_value        => deptno,
                                  p_image_n      => 'go_button.gif'
                                 )
       END LINK,
       ename, job, hiredate
  FROM emp

1753
PSOUG / Oracle Lawsuit Against SAP Delayed Until 2010
« on: June 02, 2009, 08:21:58 AM »
http://money.cnn.com/news/newsfeeds/articles/djf500/200906020738DOWJONESDJONLINE000239_FORTUNE5.htm

FRANKFURT -(Dow Jones)- The trial in Oracle Corp.'s (ORCL) lawsuit against German software company SAP AG (SAP) over SAP's former subsidiary TomorrowNow has again been postponed to Nov. 1, 2010, according to a court document posted on a Web site run by SAP.

The trial was originally scheduled to be heard by a U.S. district court in San Francisco in February 2010, but in May the two companies asked to have the start of litigation postponed until June 2010.

U.S. software firm Oracle brought a lawsuit against SAP in March 2007, alleging that TomorrowNow Inc., which SAP bought in 2005, illegally obtained and reused Oracle software-support documentation.

SAP has already admitted some wrongdoing by TomorrowNow employees, and SAP shut down TomorrowNow in October 2008.

1754
PSOUG / OAUG (Oracle Applications Users Group) News
« on: May 13, 2009, 08:28:16 AM »
OAUG News
President’s Corner

2009 OAUG President Ray Payne

COLLABORATE 09: Technology and Applications Forum for the Oracle Community was, once again, a big success, bringing attendees an intensive and relevant learning experience. I was very pleased to hear from many attendees that the education sessions, executive presentations, hands-on labs and conversations with peers were invaluable and sure to translate into immediate and positive contributions back on the job — so critical as demands continue to grow while resources dwindle.

I also heard that it was a challenge for conference attendees to choose from the many, many excellent sessions presented at COLLABORATE — too many choices, not enough time. But it’s not too late to catch a session that you may have missed or share your favorite session with a colleague. And, if you were unable to attend the conference, the OAUG is making it possible for COLLABORATE 09 to come to you. How?

    * New this year, we recorded 150 hours of content from the COLLABORATE 09 — OAUG Forum. These recordings will be available for purchase in the next few weeks. You will have the flexibility to select a single session or create a customized learning package.
    * In addition, hundreds of informative papers from the COLLABORATE 09 — OAUG Forum will soon be available, free to OAUG members. We anticipate that the papers will be available for download before the end of June.

Watch for announcements about the availability of the COLLABORATE 09 conference papers and audio recordings.

Providing relevant, high-quality educational opportunities and resources for members is one of the cornerstones of the OAUG’s mission. We hope you find the conference papers and recorded sessions useful additions to your learning and development tool kit.

Let us hear from you. What did you like about COLLABORATE 09? What can we do better? The conference survey is open through Friday, May 22. Please take 10 minutes to share your opinions, which are important to us as we plan for COLLABORATE 10 and beyond.

For more on the happenings and highlights at COLLABORATE 09, read on in this issue of OAUG eNews.


OAUG Users Community Grows Through Geo/SIG Membership Campaign

Three groups participated in the 2009 Geo/SIG Membership Campaign for OAUG to recruit new OAUG members. We appreciate your participation in this program.

    * Atlanta OAUG, Andrew Snyder, Geo Coordinator
    * Contracts SIG, Chiranjib Sarkar, SIG Coordinator
    * Michigan OAUG, Betty Noel, Geo Coordinator

Thanks to these Geo/SIG groups for a job well done and for their support in expanding the outreach of the OAUG community.


Upcoming Geo/SIG Meetings

    * Process Manufacturing SIG Conference Call
      May 12, 2009
    * ORUG Functional SIG Teleconference
      May 14, 2009
    * British Columbia OAUG
      May 14, 2009
      Victoria, British Columbia, Canada
    * Twin Cities Financial OAUG
      May 21, 2009
      Bloomington, MN
    * Michigan OAUG
      June 3, 2009
      Warren, MI
    * Healthcare Industry Users Group
      Interact 09
      June 7 - 10, 2009
      Scottsdale, AZ
    * New England OAUG
      June 8, 2009
      Worcester, MA
    * Process Manufacturing SIG Conference Call
      June 9, 2009
    * Atlanta OAUG
      June 19, 2009
    * Ohio Valley OAUG
      June 19, 2009
      Wilmington, OH
    * Pittsburgh OAUG
      June 19, 2009
      Washington, PA
    * OTM SIG Conference
      June 21 - 24, 2009
      Philadelphia, PA
    * Southwest Regional OAUG
      July 24, 2009
      Newport Beach, CA
    * Michigan OAUG
      July 27, 2009
      Plymouth, MI

Oracle E-Business Suite Release 12.1 Now Available

Oracle has announced general availability of the Oracle E-Business Suite Release 12.1 to help companies and organizations more effectively compete in today’s economy. This latest release of the Oracle E-Business Suite provides product enhancements across human resources, supply chain management, procurement, projects, master data management, customer relationship management and financials.

1755
PSOUG / Re: Web Service Application
« on: May 13, 2009, 08:17:34 AM »
So you wouldn't do it from inside Oracle within a PL/SQL-Package working as a daemon (would run once a day for two hours - I hope)?.
I personally wouldn't do it that way, but you could do it that way if you really wanted to. It's not the ideal way to do this kind of thing, however.


I suppose because of missing Oracle functions handling internet content?
But it would work with HTP, URI...packages?
The reason I wouldn't do it that way is because it's inefficient and it's the wrong tool for the job, in my opinion. Oracle is a database; let the database do what it's good at and use other tools or languages to do all the other stuff. Let the database do the heavy lifting where it excels, and don't waste its time or resources doing stuff it's not suited for. Oracle is a great database, but it's not the best tool to do text processing, remote content retrieval, or inline data reformatting. That's where I'd use something like PHP.


On the other side, with PHP + AppServer I would have another two instances to be maintained. And a problem, I don't speak PHP yet.
In general, PHP doesn't require any ongoing maintenance once it''s installed. It just runs.

A number of people here are fairly proficient in PHP, so feel free to ask for help if you need it. We may also be able to come up with some sample code for you if you can give us an idea of what you want to do.

Pages: 1 ... 115 116 [117] 118 119 ... 121