Page 1 of 2

UseOracleDatabase()

Posted: Tue Oct 25, 2011 12:31 pm
by gnozal
UseOracleDatabase() for native ORACLE database support.

The open source (french!) OCILIB library may be used.
The OCILIB library :

- offers a rich, full featured and easy to use API
- runs on all Oracle platforms
- is written in pure ISO C code with native ISO C Unicode support
- encapsulates OCI (Oracle Call Interface)
- is the most complete available OCI wrapper

Code: Select all

+-----------------------------------------------------------------------------------------+
|                                                                                         |
|                               OCILIB - C Driver for Oracle                              |
|                                                                                         |
|                                (C Wrapper for Oracle OCI)                               |
|                                                                                         |
|                              Website : http://www.ocilib.net                            |
|                                                                                         |
|             Copyright (c) 2007-2011 Vincent ROGIER <vince.rogier@ocilib.net>            |
|                                                                                         |
+-----------------------------------------------------------------------------------------+
|                                                                                         |
|             This library is free software; you can redistribute it and/or               |
|             modify it under the terms of the GNU Lesser General Public                  |
|             License as published by the Free Software Foundation; either                |
|             version 2 of the License, or (at your option) any later version.            |
|                                                                                         |
|             This library is distributed in the hope that it will be useful,             |
|             but WITHOUT ANY WARRANTY; without even the implied warranty of              |
|             MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU           |
|             Lesser General Public License for more details.                             |
|                                                                                         |
|             You should have received a copy of the GNU Lesser General Public            |
|             License along with this library; if not, write to the Free                  |
|             Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.          |
|                                                                                         |
+-----------------------------------------------------------------------------------------+

Re: UseOracleDatabase()

Posted: Tue Oct 25, 2011 12:51 pm
by Kiffi
+1

That would be very useful

Greetings ... Kiffi

Re: UseOracleDatabase()

Posted: Tue Oct 25, 2011 1:23 pm
by IdeasVacuum
+10 Very good idea 8)

Re: UseOracleDatabase()

Posted: Wed Jul 11, 2012 4:03 pm
by RomanR
+ 10 I need this feature very much 8) (ODBC is not convenient, TNSNAMES.ORA on Client-PCs available ...)

Re: UseOracleDatabase()

Posted: Thu Aug 30, 2012 8:42 pm
by Michael42
+100 :D

This would move PB ahead of the .Net world with regards to enterprise based applications.

If you need someone to help test this I'd be glad to help. I am Oracle Certified (OCP 11g, 10g, 9i) and a published Oracle author. I am at your service.

Michael

Re: UseOracleDatabase()

Posted: Sun Nov 18, 2012 2:08 pm
by Michael42
Keep this wish alive guys. It could really be profound. Being able to connect directly to Oracle WITHOUT ODBC or JDBC would be a huge feature for PB. Hey, PHP and other languages have an OCI connection method - it is time for PB to have it!

+100

Re: UseOracleDatabase()

Posted: Wed Mar 27, 2013 1:27 pm
by Michael42
Keep this feature request alive please.

Thanks.

Re: UseOracleDatabase()

Posted: Wed Mar 27, 2013 1:32 pm
by ts-soft
I don't think, pb will native support a LGPL Lib. Only Public Domain, MIT ...

Re: UseOracleDatabase()

Posted: Thu Jun 27, 2013 8:23 am
by nicolaus
+100000
at the moment i use also ODBC for connection to oracle.
It will be very nice if we can have a native orackle lib in PB.

@PB Team please include this one!

Re: UseOracleDatabase()

Posted: Thu Oct 24, 2013 7:20 pm
by Michael42
Can anyone comment as to if work has started on adding this feature?

I'd be glad to help test this.

Thanks!

Michael

Re: UseOracleDatabase()

Posted: Thu Oct 24, 2013 10:47 pm
by IdeasVacuum
...it's a two years old post, can't believe how quickly those two years have flown by. Support for Oracle would be a very fine enhancement as Oracle is popular in the manufacturing industry.

....This post has over 1400 views!

Re: UseOracleDatabase()

Posted: Wed Jun 04, 2014 1:21 pm
by byo
+100000

Please Fred & freak, add this.
If you need help with it please let me know.
But please make it happen. :-)

Re: UseOracleDatabase()

Posted: Tue Aug 05, 2014 10:25 am
by nicolaus
@ Fred & freak

can you give us a short statment about this fearure request?

Thanks,
Nico

Re: UseOracleDatabase()

Posted: Tue Aug 05, 2014 10:38 am
by Fred
It's LGPL, so we can't include it in PB as a static lib. You should still be able to access it with importc/endimport.

Re: UseOracleDatabase()

Posted: Tue Aug 05, 2014 11:58 am
by nicolaus
Fred wrote:It's LGPL, so we can't include it in PB as a static lib. You should still be able to access it with importc/endimport.
Thanks for the info Fred.