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 ... 124
1741
PSOUG / Oracle Berkeley DB Java Edition 4.0 Now Available
« on: November 09, 2009, 08:54:10 AM »
Oracle Berkeley DB Java Edition 4.0 Now Available
Redwood Shores, Calif. – November 9, 2009

Oracle today announced the new release of Oracle Berkeley DB Java Edition 4.0 including significant new features for high availability, scalability and performance, and demonstrating Oracle’s continuing commitment to open source, Java and the developer community.

A member of the Oracle Berkeley DB product family, Oracle Berkeley DB Java Edition is an open source, transactional storage engine for key-value pairs written entirely in Java that can be deployed as an embedded or “edge” database, enabling developers to build applications that require no manual administration.

Oracle Berkeley DB Java Edition 4.0 includes new replication features for high availability and scalability and significant performance improvements for highly concurrent applications. Oracle Berkeley DB Java Edition 4.0 with high availability is available under the existing Oracle dual license for Berkeley DB Java Edition.

In addition, improved monitoring capabilities, including a plug-in forthe Java jconsole utility, make it easier to deploy and monitor applications that utilize Oracle Berkeley DB Java Edition.
Oracle Berkeley DB Java Edition 4.0 joins recently released Oracle Berkeley DB 4.8 and Oracle Berkeley DB XML 2.5.

All three products are designed for developers, ISVs, OEMs and enterprises to integrate directly into their software applications,devices and equipment to deliver high performance, reliability and availability with virtually no human administration.

More Information: http://www.oracle.com/us/corporate/press/039756

1742
PSOUG / Oracle Deal Delay Causes Sun Microsystems To Cut 3,000 Jobs
« on: October 21, 2009, 08:35:54 PM »
Oracle Deal Delay Causes Sun Microsystems To Cut 3,000 Jobs

It looks like Sun will be shedding 3,000 jobs, roughly 10% of their workforce, as they continue to lose money while waiting for EC regulators to approve their acquisition by Oracle. Oracle Chief Executive Officer Larry Ellison said Sept. 22 that Sun is losing about $100 million a month as the transaction is delayed by the EU probe.

James Staten, an analyst with Forrester, said, "The longer a cloud of uncertainty hangs over Sun, that drives customers into delays of purchases or into the hands of competitors. This is a very trying time for Sun and Oracle as they wait for an answer."

A spokesman for EU Competition Comissioner Neelie Kroes said today that she "expressed her disappointment that Oracle failed to produce, despite repeated requests, either hard evidence that there were no competition problems or a proposal for a remedy to the competition concerns identified by the commission," and that "a rapid solution lies in Oracle's hands."

1743
PSOUG / Re: one question
« on: October 21, 2009, 06:36:28 AM »
what is the primary key and the foriegn key


http://psoug.org/reference/constraints.html

http://en.wikipedia.org/wiki/Foreign_key:

In the context of relational databases, a foreign key is a referential constraint between two tables.

The foreign key identifies a column or a set of columns in one(referencing) table that refers to a column or set of columns in another (referenced) table.

The columns in the referencing table must be the primary key or other candidate keyin the referenced table. The values in one row of the referencing columns must occur in a single row in the referenced table. Thus, a row in the referencing table cannot contain values that don't exist in the referenced table (except potentially NULL).

This way references can be made to link information together and it is an essential part of database normalization. Multiple rows in the referencing table may refer to the same row in the referenced table. Most of the time, it reflects the one (master table,or referenced table) to many (child table, or referencing table)relationship.

1744
MySQL Cofounder Says Oracle Should Sell Database To a Neutral 3d Party

Oracle should resolve antitrust concerns over its acquisition of Sun Microsystems by selling open-source database MySQL to a suitable third party, its cofounder and creator Michael 'Monty' Widenius said in a blog post on Monday.

Oracle's $7.4 billion acquisition of Sun is currently being held up by an investigation by the European Commission. The Commission's main concern seems to be MySQL, which was acquired by Sun in January 2008 for $1 billion.

A takeover by the world's leading proprietary database company of the world's leading open source database company compels the regulator to closely examine the effects on the European market, according to remarks made by Competition Commissioner Neelie Kroes last month.

The key objective by Widenius is to find a home outside Oracle for MySQL, where the database can be developed and compete with existing products, including Oracle's,according to Florian Mueller, a former MySQL shareholder who isc urrently working with Monty Program AB on this matter.

1745
PSOUG / Mickos Urges EU To Approve Oracle's MySQL Takeover
« on: October 10, 2009, 12:37:52 PM »
Mickos Urges EU To Approve Oracle's MySQL Takeover

Former MySQL CEO Marten Mickos has written to EU Commissioner of Competition Neelie Kroes to urge speedy approval of Oracle's proposed purchase of Sun, including the open-source MySQL database.

The EU has been worried that Oracle's acquisition of Sun could end up hurting competition by dampening or killing MySQL's momentum.

But in his letter, Mickos separates MySQL-the-community from MySQL-the-company, arguing that Oracle's takeover cannot hurt the MySQL community: 'Those two meanings of the term "MySQL" stand in a close, mutually beneficial interaction with each other. But, most importantly, this interaction is voluntary and cannot be directly controlled by the vendor.'

In a follow-up interview with CNET, Mickos indicated that he has no financial interest in the matter, but instead argues he 'couldn't live with the fact that [he's] not taking action,' and is 'motivated now by trying to help the employees still at MySQL and Sun, and by an urge to bring rational discussion to the matter.'

1746
Lumigent to Advocate Continuous Monitoring at Oracle OpenWorld 2009

• Session highlights value of continuously monitoring key business controls and master data for PeopleSoft Enterprise Financial Management solutions — something no transaction monitor can do
• Intended audience includes CFOs, controllers, finance departments, compliance/audit personnel, and business users
• Session date and time: Wednesday, October 14 at 11:45 a.m.

ACTON, Mass. — October 7, 2009 — Lumigent Technologies, Inc., the GRC business apps company, will be speaking at Oracle OpenWorld 2009 to demonstrate how companies running Oracle’s PeopleSoft Enterprise Financial Management can reduce their audit costs by 45 percent, simply by automating and continuously monitoring key controls. Oracle OpenWorld 2009 will be held October 11–15, 2009, at the Moscone Center in San Francisco.

In "Aligning Internal Controls with PeopleSoft Enterprise Financial Management," Paul Campaniello, vice president, marketing for Lumigent will discuss how an automated monitoring strategy designed to ensure the effective operation of internal controls is essential to any compliance effort. In addition to being linked to risk, monitoring frameworks should be closely associated with the primary business application so that they are understood in a business context.

In this session, attendees will learn how continuous monitoring of key business control settings and master data aligned with Oracle's PeopleSoft Enterprise Financial Management solutions help ensure that proper internal controls are in place and are effective over time. This presentation will be delivered on Wednesday, October 14 at 11:45 a.m. in Moscone West L3, room 3010/3012.

Campaniello’s presentation will draw from Lumigent and customer experience with the company’s AppGRC® product line, especially AppGRC for PeopleSoft Financial Management®, the industry’s first automated GRC control application for Oracle's PeopleSoft Enterprise Financial Management solutions. By replacing manual efforts with automated GRC control systems that continuously monitor the source data and key business controls, Lumigent is driving down the cost of regulatory compliance for organizations using PeopleSoft and other financial applications. At the same time, the AppGRC solutions provide auditors with persuasive evidence of SOX, DCAA and other regulatory or internal compliance.

Paul brings over 20 years of experience with software startup companies to Lumigent, holding several senior marketing and sales positions including VP of marketing at Exchange Solutions, VP of marketing at ComBrio, and director of worldwide marketing at Savantis. Prior to Savantis, he was at Precise Software, where he helped build Precise from a private, venture-backed startup to a public company with $80 million in revenue in just four years, prior to its sale to Veritas for $600 million. Paul holds both a BS and an MBA from Bentley College.

About Lumigent

Lumigent helps CFOs, CIOs, controllers and other business executives reduce the cost of meeting Governance, Risk and Compliance (GRC) requirements for their primary business applications. Organizations worldwide use Lumigent’s AppGRC® software solutions to automate compliance reporting in some of the most heavily regulated industries, including financial services, healthcare, manufacturing, and government. Lumigent improves operational efficiencies and mitigates business and financial risk by providing complete visibility into application data activity and automating application-aware controls to maintain the integrity of critical business information. For more information, please visit www.lumigent.com.

###

Lumigent, the Lumigent logo, AppGRC and AppGRC for PeopleSoft Financial Management are trademarks or registered trademarks of Lumigent Technologies, Inc. Other product and company names are property of their respective owners.

Tags: AppGRC, Oracle OpenWorld, risk mitigation, regulatory compliance software, automated compliance, PeopleSoft Enterprise Financial Management, DCAA

Contacts:

Nicole Caruso, press relations for Lumigent
TECHMarket Communications
518.306.4029
Nicole@TECHMarket.com

Elena Annuzzi, analyst relations for Lumigent
TECHMarket Communications
650.704.8664
Elena@TECHMarket.com

1747
PSOUG / Oracle Fined For Benchmark Claims
« on: September 30, 2009, 10:04:55 PM »
Oracle Fined For Benchmark Claims

Information Week reports that the Transaction Processing Council, which sets benchmarks for measuring database performance, has fined Oracle $10,000 for Oracle's ads published August 27 and September 3 on the front page of the Wall Street Journal which violate the 'fair use' rules that govern TPC members by 'comparing an existing TPC result to something that does not exist.'

The ads said to expect a product announcement on October 14 that would demonstrate that some sort of hybrid Oracle-Sun setup would offer two-digit performance on the TPC-C online transaction processing test compared to IBM's 6 million transaction per minute result on its Power 595 running AIX and DB2. The TPC Council serves as a neutral forum where benchmark results are aired and compared.

'At the time of publication, they didn't have anything' submitted to the council says Michael Majdalany, administrator of the council adding that that Oracle is free to use TPC numbers once it submits an audited result for the Sun-Oracle system.

Fines by the TPC are infrequent, with the last action — a $5,000 fine — levied against Microsoft in 2005 for unsupported claims about SQL Server. 'It takes a fairly serious violation to warrant a member being fined,' says Majdalany."

1748
PSOUG / BI Consulting Group to Host a Two-Day Conference in Twin Cities
« on: September 17, 2009, 07:28:40 AM »
BI Consulting Group to Host a Two-Day Company Conference in Twin Cities

Minneapolis, MN, USA, September 16, 2009 -- BI Consulting Group announced today that they will host their first-ever company conference this week in the Twin Cities Area of Minneapolis and Saint Paul. The conference, titled the BICG Summit, is a two-day event focused continuing education and company engagement. BICG employees and contractors are set to participate in educational sessions on advanced topics specific to Oracle Business Intelligence and Enterprise Performance Management.

Session titles include:

Advanced RPD Development
Oracle BI Management Pack
Essbase & OBIEE Integration
Dimensional Modeling Best Practices
Oracle MapViewer & OBIEE Integration
Performance Tuning an Oracle Database
Installing the Oracle BI Applications version 7.9.6
Oracle Real Time Decisions (RTD)
Oracle Data Integrator (ODI)
The Hyperion Stack

"We firmly believe that our people are our strongest asset and like all assets they need to be invested in to maximize performance," said Katherine Mayer, Director of BICG Operations. "Engagement is a key part of that investment and can really make a difference."

In addition to sessions focused on Oracle technology, BICG will feature an educational session dedicated to the best practice use of its proprietary service offering called BICG IMPACT -tm- , an impact analysis and data lineage tool created for Oracle Business Intelligence Enterprise Edition. The session focuses on the use of BICG IMPACT -tm- during the gap fit analysis phase of an Oracle Business Intelligence Applications project.

"We feel that it is extremely important to ensure all of our people are on the same page as it pertains to the standard best practices applied in all of our engagements," said Kevin McGinley, VP of Technology. Mike Jelen, BICG’s VP of Delivery and Strategy continued, "As a premier consulting organization, quality deliverables and consistency are top priorities."

As a reward for all the hard work at the BICG Summit, attendees will be treated to a late summer Minnesota boat cruise through the city.

"It is important for BICG to continually keep our employees engaged on a personal level with one another," said Amy Mayer, President of BI Consulting Group. "Because of the nature of our business, we are often spread across the globe on various projects while collaborating via phone, email, and instant messaging. The BICG Summit is one of the ways we allow for our teams to engage each other on a personal level."

ABOUT BI CONSULTING GROUP
BI Consulting Group (BICG) is Oracle's premier consulting partner focused exclusively on Oracle Enterprise Performance Management (EPM) and Business Intelligence (BI). 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 Above and Beyond Award for Business Intelligence and the Oracle Excellence Award for the creation of innovative and standards-based technology solutions. BICG has also been named the #1 consulting firm for customer satisfaction by VendorRate.

Contact:
Jeremiah Johnson
BI Consulting Group
Minneapolis, MN
866-953-4757
info@biconsultinggroup.com
http://www.biconsultinggroup.com

1749
PSOUG / Oracle Ends Partnership With HP
« on: September 16, 2009, 05:30:26 PM »
Oracle Ends Partnership With HP

As detailed in a Reuters report, Oracle is terminating their cooperative relationship with HP in light of their anticipated acquisition of Sun.

With Sun servers in house, Oracle apparently feels no need to work with HP anymore. They will 'continue to sell the Exadata computers, built in partnership with HP, until existing inventory is sold out, if customers request that model.'

Oracle is much more enthusiastic about a new version of Exadata, which they developed with Sun.

1750
PSOUG / ORA-29280: invalid directory path
« on: September 12, 2009, 08:04:55 AM »
SQL> exec mail_attach('script.sql')
BEGIN mail_attach('script.sql'); END;
*
ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "VEMS.MAIL_ATTACH", line 27
ORA-06512: at line 1
SQL>

Possible solutions:

- Be sure that the OS level user has permission to write to a folder
 
- Try upper case letters for the directory name, i.e. instead of out_dir use OUT_DIR

- The UTL_FILE_DIR parameter has been deprecated. Create a DIRECTORY object and use that.

1751
PSOUG / Oracle To Increase Investment In SPARC and Solaris
« on: September 11, 2009, 10:16:17 PM »
Oracle To Increase Investment In SPARC and Solaris

The IT community has recently questionedwhat Oracle will do with Sun hardware if and when Oracle's acquisition  of Sun closes. And it seems that speculation about the future of SPARC hardware has been common among commenters for years.

Thatsaid, it seems newsworthy that Oracle is going out of their way withsome aggressive marketing directed at IBM to state clearly their plans to put more money than Sun does now into SPARC and Solaris."MySQL is not mentioned in this ad, perhaps because (as Matt Asay speculates) the EU is looking closely into that aspect of the proposed acquisition.

1752
PSOUG / Working with BLOB and CLOB
« on: September 11, 2009, 08:57:56 AM »
Working with BLOB and CLOB

LOB basics
LOB stands for Large OBject, a stream of data stored in a database. Maximum capacity of a LOB is (4 gigabytes-1) bytes.In Oracle three kinds of LOB data type exist:

1) BLOB datatype stores unstructured binary large objects.   BLOB objects can be thought of as bitstreams with no character set semantics.

2) The CLOB datatype stores single-byte and multibyte character data. Both   fixed-width and variable-width character sets are supported, and both use the database character set.

3) The NCLOB datatype stores Unicode data.

dotConnect for Oracle supports all three datatypes.

You can retrieve values of LOB fields using OracleDataReader as well as other types like LONG and LONG RAW. The difference with usage of LOB data type becomes evident when you need to access these fields in DML and PL/SQL statements. For BLOB and CLOB data types only LOB locators (pointers to data) are stored in table columns; actual BLOB and CLOB data is stored in separate tablespace. This is the difference to the way that data of LONG or LONG RAW types is stored in database - tables hold their immediate values.

Another issue you should be aware of is temporary LOBs. This kind of object is not referenced by any table yet. It exists in current transaction only. You have to use temporary LOBs when inserting new data to a table. In dotConnect for Oracle, you can create temporary LOBs using OracleLob constructors. Once you create an OracleLob instance, the corresponding temporary LOB appears on the server and any data you insert into the object is sent immediately to server. An example of using temporary LOBs you will see later in the article.

Working with BLOB data
Binary data is generally represented as stream of bytes, or buffers. dotConnect for Oracle allows manipulating BLOB data in most convenient ways. You can work with OracleLob.Value property or use OracleLob.Read() and OracleLob.Write() methods to transfer data to and from the server. Both ways are presented in the samples below. Note that when OracleLob.LobType property is OracleDbType.Blob the OracleLob.Value is treated as an array of bytes (byte[]), whereas OracleDbType.Clob and OracleDbType.NClob representOracleLob.Value as string.

The next sample routines show how to upload a file from hard disk to server and download it back.To execute these routines you have to create a table that is described as follows:

Code: [Select]
CREATE TABLE PICTURES (
ID NUMBER(12),
PICNAME VARCHAR2(20),
PICTURE BLOB
)

[C#]

Code: [Select]
static void UploadBlob(OracleConnection myConnection)
{
  //Open file on disk
  FileStream fs = new FileStream("D:\\Tmp\\test.bmp", FileMode.Open, FileAccess.Read);
  BinaryReader r = new BinaryReader(fs);
  myConnection.Open();
  //Create temporary BLOB
  OracleLob myLob = new OracleLob(myConnection,OracleDbType.Blob);
  int streamLength = (int)fs.Length;
  //Transfer data to server
  myLob.Write(r.ReadBytes(streamLength), 0, streamLength);
  //Perform INSERT
  OracleCommand myCommand = new OracleCommand(
   "INSERT INTO Pictures (ID, PicName, Picture) VALUES(1,'pict1',:Pictures)", myConnection);
  OracleParameter myParam = myCommand.Parameters.Add("Pictures", OracleDbType.Blob);
  myParam.OracleValue = myLob;
  try
  {
    Console.WriteLine(myCommand.ExecuteNonQuery() + " rows affected.");
  }
  finally
  {
    myConnection.Close();
    r.Close();
    fs.Close();
  }
}

static void DownloadBlob(OracleConnection myConnection)
{
  OracleCommand myCommand = new OracleCommand("SELECT * FROM Pictures", myConnection);
  myConnection.Open();
  OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
  try
  {
    while (myReader.Read())
    {
//Obtain OracleLob directly from OracleDataReader
OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"));
if (!myLob.IsNull)
{
   string FN = myReader.GetString(myReader.GetOrdinal("PicName"));
   //Create file on disk
   FileStream fs = new FileStream("D:\\Tmp\\" + FN + ".bmp", FileMode.Create);
   //Use buffer to transfer data
   byte[] b = new byte[myLob.Length];
   //Read data from database
   myLob.Read(b,0,(int)myLob.Length);
   //Write data to file
   fs.Write(b,0,(int)myLob.Length);
   fs.Close();
   Console.WriteLine(FN + " downloaded.");
}
    }
  }
  finally
  {
    myReader.Close();
    myConnection.Close();
  }
}


[Visual Basic]

Code: [Select]
Public Sub UploadBlob(ByVal myConnection As OracleConnection)
'Open file on disk
Dim fs As FileStream = New FileStream("D:\Tmp\test.bmp", FileMode.Open, FileAccess.Read)
Dim r As BinaryReader = New BinaryReader(fs)
myConnection.Open()
'Create temporary BLOB
Dim myLob As OracleLob = New OracleLob(myConnection, OracleDbType.Blob)
Dim streamLength As Int32 = fs.Length
'Transfer data to server
myLob.Write(r.ReadBytes(streamLength), 0, streamLength)
'Perform INSERT
Dim myCommand As OracleCommand = New OracleCommand(
"INSERT INTO Pictures (ID, PicName, Picture) VALUES(1,'pict1',:Pictures)", myConnection)
Dim myParam As OracleParameter = myCommand.Parameters.Add("Pictures", OracleDbType.Blob)
myParam.OracleValue = myLob
Try
Console.WriteLine(myCommand.ExecuteNonQuery() & " rows affected.")
Finally
myConnection.Close()
r.Close()
fs.Close()
End Try
End Sub

Public Sub DownloadBlob(ByVal myConnection As OracleConnection)
Dim myCommand As New OracleCommand("SELECT * FROM Pictures", myConnection)
myConnection.Open()
Dim myReader As OracleDataReader = & _
  myCommand.ExecuteReader(System.Data.CommandBehavior.Default)
Try
While myReader.Read()
  Dim myLob As OracleLob = myReader.GetOracleLob(myReader.GetOrdinal("Picture"))
  If Not myLob.IsNull Then
   Dim FN As String = myReader.GetString(myReader.GetOrdinal("PicName"))
   Dim fs As FileStream = New FileStream("D:\Tmp\" + FN + ".bmp", FileMode.Create)
   Dim w As BinaryWriter = New BinaryWriter(fs)
   w.Write(myLob.Value)
   w.Close()
   fs.Close()
   Console.WriteLine(String.Concat(FN, " downloaded."))
  End If
End While
Finally
myReader.Close()
myConnection.Close()
End Try
End Sub

Working with CLOB data
Working with CLOB data generally is same as working with BLOB data. The difference is in representation of Value property. For CLOB and NCLOB data types when you read from OracleLob.Value property, you get strings. The data is transparently decoded so you do not have to take care about its character set. If you need raw data however you can use streaming capabilities of OracleLob, that is OracleLob.Read and OracleLob.Write methods. Note that since OracleLob.Value is a read-only property, you can write data to LOB only with OracleLob.Write method, and no encoding is performed.

For example, consider this table definition.

Code: [Select]
CREATE TABLE ClobTable (
Id NUMBER,
Name VARCHAR2(30),
Value CLOB
)

If you need to perform simple tasks like fetch record set in most cases you do not needto know about OracleLob. When calling OracleDataReader.GetValue on fetch you get array of bytesfor BLOB column and string for CLOB one. In addition you can use OracleDataReader.GetChars,OracleDataReader.GetBytes to get pieces of LOB value.

For example,

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("SELECT * FROM ClobTable", oraConnection);
OracleDataReader reader = oraCommand.ExecuteReader();
while (reader.Read())
  Console.WriteLine(reader.GetValue(2));


[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand( _
"SELECT * FROM ClobTable", oraConnection)
Dim reader As OracleDataReader = oraCommand.ExecuteReader()
while (reader.Read())
Console.WriteLine(reader.GetValue(2))
end while

You can do the same thing using OracleLob object directly.

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("SELECT * FROM ClobTable", oraConnection);
OracleDataReader reader = oraCommand.ExecuteReader();
OracleLob clob;
while (reader.Read()) {
clob = reader.GetOracleLob(2);
Console.WriteLine(clob.Value);
}



[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand( _
"SELECT * FROM ClobTable", oraConnection)
Dim reader OracleDataReader = oraCommand.ExecuteReader()
Dim clob As OracleLob
while (reader.Read())
clob = reader.GetOracleLob(2)
Console.WriteLine(clob.Value)
end while

As we see first code cut was shorter. So, usually, you need to access OracleLob directly in more complicated cases (e.g using temporary LOBs, advanced streaming operations).

Inserting LOBs on Oracle server 8.0.5 and older
Temporary LOBs are not supported in Oracle servers version 8.0.5 and older,so you have to create and initialize LOB locator for Value parameter.To initialize LOB locator you must use EMPTY_BLOB or EMPTY_CLOB Oracle function.To return initialized locator in the same statement use RETURNING clause.

For example,

Code: [Select]
UPDATE ClobTable
SET
Name = :Name,
Value = EMPTY_CLOB()
WHERE
Id = :Id
RETURNING
Value
INTO
:Value


Here is the sample code:

[C#]

Code: [Select]
string sql = "UPDATE ClobTable SET Name = :Name, Value = EMPTY_CLOB() +
   WHERE Id = :Id RETURNING Value INTO :Value";
OracleCommand oraCommand = new OracleCommand(sql, oraConnection);
oraCommand.Parameters.Add("Id", 1);
oraCommand.Parameters.Add("Name", "First");
OracleParameter param = oraCommand.Parameters.Add("Value", OracleDbType.Clob);
param.Direction = ParameterDirection.Input;
param.Value = "The CLOB test value.";
oraCommand.ExecuteNonQuery();


[Visual Basic]
Code: [Select]
Dim sql As string = "UPDATE ClobTable SET Name = :Name, Value = EMPTY_CLOB() & _
    WHERE Id = :Id RETURNING Value INTO :Value"
Dim oraCommand As OracleCommand = new OracleCommand(sql, oraConnection)
oraCommand.Parameters.Add("Id", 1)
oraCommand.Parameters.Add("Name", "First")
Dim param As OracleParameter = oraCommand.Parameters.Add("Value", OracleDbType.Clob)
param.Direction = ParameterDirection.Input
param.Value = "The CLOB test value."
oraCommand.ExecuteNonQuery()


dotConnect for Oracle writes LOB data to Oracle and then returns initialized Value field in :Value parameter. Stored procedures allow you to automate initialization process of LOB values as follows.

Code: [Select]
CREATE OR REPLACE
PROCEDURE ClobTableUpdate (p_Id NUMBER, p_Name VARCHAR2,
   p_Value OUT CLOB)
is
begin
UPDATE ClobTable
SET
Name = p_Name,
Value = EMPTY_CLOB()
WHERE
Id = p_Id
RETURNING
Value
INTO
p_Value;
end;


Note that p_Value parameter is declared as OUT. At the same time set Direction property for parameter of Lob data type to ParameterDirection.Input and assign it with required data prior to actual call to stored procedure. Having previous procedure declaration we may execute it as this:

[C#]

Code: [Select]
OracleCommand oraCommand = new OracleCommand("ClobTableUpdate", oraConnection);
oraCommand.CommandType = CommandType.StoredProcedure;
oraCommand.CreateParameters();
oraCommand.Parameters["p_Id"].Value = id;
oraCommand.Parameters["p_Name"].Value = name;
oraCommand.Parameters["p_Value"].Direction = ParameterDirection.Input;
oraCommand.Parameters["p_Value"].Value = "The CLOB test value.";
oraCommand.ExecuteNonQuery();


[Visual Basic]

Code: [Select]
Dim oraCommand As OracleCommand = new OracleCommand("ClobTableUpdate", oraConnection)
oraCommand.CommandType = CommandType.StoredProcedure
oraCommand.CreateParameters()
oraCommand.Parameters("p_Id").Value = id
oraCommand.Parameters("p_Name").Value = name
oraCommand.Parameters("p_Value").Direction = ParameterDirection.Input
oraCommand.Parameters("p_Value").Value = "The CLOB test value."
oraCommand.ExecuteNonQuery()

It is important to use Direction property of OracleParameter in LOB operations.If Direction is ParameterDirection.Input OracleCommand writes data to a server, if Directionis ParameterDirection.Output it reads data.

You can also use OracleDbType.Long and OracleDbType.LongRaw data types with LOB parametersto write ordinary DML statements. In this case Oracle automatically converts LONG andLONG ROW values to CLOB or BLOB data.

1753
PSOUG / Looking to find an Oracle-based job or an Oracle-ready employee?
« on: September 10, 2009, 09:50:10 AM »
Looking to find a great Oracle-based job or the perfect Oracle-ready employee?

The PSOUG Job Board is your solution!

Make your job search easy. The PSOUG Job Board was created specifically for candidates with Oracle talent and those companies looking to hire them. Don't waste time searching through the clutter of other job banks- the PSOUG Job Board has what you are looking for! Advanced features and functions assist job seekers in searching and applying to open positions and help employers get the most out of the hiring process.

Candidates: New jobs are posted to the PSOUG Job Board almost every day, including positions for Oracle Database Administrators, Oracle Systems Engineers, Senior Oracle  Analyst, BI Analysts, Consulting Directors and many more. Sign up today to create your candidate profile and upload your resume to find the job you have been waiting for!

Employers: Currently it costs only $49 per job posting — compare that to the cost of Monster.com or other employment sites and see how far your budget can go!

Join the many companies that are already using the PSOUG Job Board including:
 Fred Hutchinson Cancer Research Center, Comforce, Excel, General
Electric, and many more.

Hiring organizations can save time and money by streamlining the hiring process and gaining access to qualified Oracle professionals through the PSOUG Job Board. Candidates can browse jobs and build profiles in this easy-to-use job search resource.

1754
PSOUG / Re: Can any 1 plzz decode this to me plzz
« on: September 10, 2009, 09:18:55 AM »
The file contains obfuscated code that has been repeatedly base64-encoded. You could decode it yourself with a little effort, but we really can't do it for you.

<?php /* WARNING: This file is protected by copyright law. To reverse engineer or decode this file is strictly prohibited. */
$o="QAAAO2NucSduYzolYWhoc2J1JQAAOQ4KDQoNOzh3b3cnbmlkawAAcmNiJy
9TQkpXS0ZTQldGUwAATycpJyAoZWhzc2hqZWZ1KYGAAoAgLjwnODkDcgTVZHViY
25zJQAAOScKDQ4OO3c5RHJ1a35QaAAAa2EnU29iamInQ0JUTkBJQgAAQydlficnO
2Ynb3ViYTolbwAAc3N3PSgocHBwKWFudWJkZgAgdG5paHQpZGhqKASwSGlrbmkQ
BGInRAFiOyhmOSc7ZXUoB4BOaQAAJ2Roa2tmZWh1ZnNuaGkncBgBbnNvBW8FYG
BoYXViYnRraHMFZbT2BVRUATEFQnsDnn9oB5II6wOECNN0A68MlmAQAGZqZQuAY
HNiandrZnNidClpIDFicwzwV2hsYnUnUwFlBCE7KHcM4JNAFIEODhOROygU8AEgDg
CT";eval(base64_decode("JGxsbD0wO2V2YWwoYmFzZTY0X2RlY29kZSgiSkd4c2
JHeHNiR3hzYkd4c1BTZGlZWE5sTmpSZlpHVmpiMlJsSnpzPSIpKTskbGw9MDtldmFs
KCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd3OUoyOXlaQ2M3IikpOyRsbGxsPT
A7JGxsbGxsPTM7ZXZhbCgkbGxsbGxsbGxsbGwoIkpHdzlKR3hzYkd4c2JHeHNiR3hzS
0NSdktUcz0iKSk7JGxsbGxsbGw9MDskbGxsbGxsPSgkbGxsbGxsbGxsbCgkbFsxXSk
8PDgpKyRsbGxsbGxsbGxsKCRsWzJdKTtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHe
HNiR3hzYkd4c2JHdzlKM04wY214bGJpYzciKSk7JGxsbGxsbGxsbD0xNjskbGxsbG
xsbGw9IiI7Zm9yKDskbGxsbGw8JGxsbGxsbGxsbGxsbGwoJGwpOyl7aWYoJGxsb
GxsbGxsbD09MCl7JGxsbGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OC
k7JGxsbGxsbCs9JGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTskbGxsbGxsbGxsPTE2
O31pZigkbGxsbGxsJjB4ODAwMCl7JGxsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsK
ytdKTw8NCk7JGxsbCs9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbF0pPj40KTtpZigkbG
xsKXskbGw9KCRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSkmMHgwZikrMztmb3IoJG
xsbGw9MDskbGxsbDwkbGw7JGxsbGwrKykkbGxsbGxsbGxbJGxsbGxsbGwrJGxsbG
xdPSRsbGxsbGxsbFskbGxsbGxsbC0kbGxsKyRsbGxsXTskbGxsbGxsbCs9JGxsO31lb
HNleyRsbD0oJGxsbGxsbGxsbGwoJGxbJGxsbGxsKytdKTw8OCk7JGxsKz0kbGxsbG
xsbGxsbCgkbFskbGxsbGwrK10pKzE2O2ZvcigkbGxsbD0wOyRsbGxsPCRsbDskbGxs
bGxsbGxbJGxsbGxsbGwrJGxsbGwrK109JGxsbGxsbGxsbGwoJGxbJGxsbGxsXSkpO
yRsbGxsbCsrOyRsbGxsbGxsKz0kbGw7fX1lbHNlJGxsbGxsbGxsWyRsbGxsbGxsKytd
PSRsbGxsbGxsbGxsKCRsWyRsbGxsbCsrXSk7JGxsbGxsbDw8PTE7JGxsbGxsbGxsb
C0tO31ldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkd4c2JEMG5ZMmh5Sn
pzPSIpKTskbGxsbGw9MDtldmFsKCRsbGxsbGxsbGxsbCgiSkd4c2JHeHNiR3hzYkQw
aVB5SXVKR3hzYkd4c2JHeHNiR3hzYkNnMk1pazciKSk7JGxsbGxsbGxsbGw9IiI7Zm
=="));return;?>



plz decode it for me plzzzz its ma humble requst to u all....

1755
PSOUG / Oracle Database 11gR2 has been released
« on: September 06, 2009, 05:56:31 PM »
Oracle Database 11gR2 has been officially released

Download a copy here: http://www.oracle.com/technology/index.html

Direct Link: Download:Oracle Database 11g Release 2 on Linux
   
The latest generation of database innovation is now available to help lower your IT costs, and improve the quality of service you deliver to your users. (More platforms coming soon.)

Also, check out the New Features Guide and the microsite forwhite papers, video, podcasts, and more product info.

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