The following oo4ole poll is now closed. Here are the final results: POLL QUESTION: Do you plan to use Oracle Objects for OLE in future software applications...
oo4ole@yahoogroups.com
Nov 1, 2002 8:32 am
1484
Just a word of advice... It looks as though Oracle may be phasing this out in favor of ODP.Net of the OLEDB provider. There have been no OFFICIAL statements,...
I am using oo4o(oracle9i) in Borland C++ Builder6, I import the oip9.tlb and use the COM interface directly. But there is a strange question for me: When I...
I'm a newbie to Oracle, so please bear with me... I need to query my database using parameters from a VB form. I read over and over that it's poor form to...
Hi, I am trying to extract members of procedure of an Oracle package from visual basic. I tried to use metadata object, but I have to call recursively in case...
I will be out of the office starting 11/08/2002 and will not return until 11/18/2002. Please direct any system issues to the IT Ops Help Desk or any system...
eric.mccraw@...
Nov 12, 2002 7:01 am
1489
Is it me or is oo4o very slow to open a database? I'm using ASP>Oracle and instantiating the object using the OraSession way, and OraSession.OpenDatabase is...
i think you are using a dedicated conection for each query, and that is too slow. for better performace you can use a pool of conection that you can open in ...
I am trying to use the AddTable method for a string variable. I have set the data type to varchar2 but I am getting an error: OIP-04126: Invalid argument...
Hello There! I have a trigger on my Oracle Database so that when a record is inserted it automatically creates a new unique primary key for that record. I...
Better u use Oracle sequnces cuz ur method will fail in multiuser environment if some concurrency happenend and alter ur table and turn ur jobnum filed to...
Fahim Ahmed
fames28@...
Nov 27, 2002 5:39 am
1494
Dear all. Can any body send me a doc or the URL which lists out the APIs for main DB functionalities like ...
janakiramank@...
Nov 27, 2002 11:21 am
1495
Agree with the comment about using sequences. The way to get the value back, I would think, would be via the returning clause on your insert statement. ...
Maybe the better way for get a unique value is create a sequence for oracle and use that. you can get the next value from the sequence before insert into the...
Thank You People! I just solved my problem... Here was my solution. Private m_odaDatabase As OraDatabase Dim lngNewNum As Long Dim ossState As OraSqlStmt ...
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
I am trying to prove that OO4O is the way forward, but my current tests show it under performs our current ado COM interface. When stress testing our in-house...
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
Dear Broadvision Consultant, How are you doing! I represent Zend Consulting Services, a premier Recruitment Solutions and Executive Search firm specializing in...
I am using oo4o Class library. I am inserting arrays into the database This is my code (it is simplified): // C++ Code OStartup(); oRes = m_o_Session.Open();...
Yoav I do the smae in VB and have no problem passing null as a parameter value. Check if the table that gets the insert allows null, or the SP may not allow...
Just create an empty OValue object and add it. The default value for them is NULL. ... From: Ofer Gal To: oo4ole@yahoogroups.com Sent: Wednesday, December 11,...
I am using Visual C++ and using oo4o the ole way I am try to call stored procedure that have Clob as parameter in it seems the the OraParameters Add method...
hi there how is your preparation for oracle certification going on 3 selftests of oracle 9i dba track are available only for $60 sql9i fundamental1 ...
I have a huge MFC/C++ application with about 1000 SQL statements embedded in it. Mostly it uses oo4o (there's also some legacy ODBC/CRecordset stuff I'm...
I don't have any examples of OO4O in any flavor of C, but I can answer your other questions. OO4O is an install option of the Oracle client installation, so...
I am trying to access a store proc that has an optional parameter. I have not been able to get this to work in code using OO4O. Any help is appreciated. The...