UseOracleDatabase()

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
gnozal
PureBasic Expert
PureBasic Expert
Posts: 4229
Joined: Sat Apr 26, 2003 8:27 am
Location: Strasbourg / France
Contact:

UseOracleDatabase()

Post 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.          |
|                                                                                         |
+-----------------------------------------------------------------------------------------+
For free libraries and tools, visit my web site (also home of jaPBe V3 and PureFORM).
User avatar
Kiffi
Addict
Addict
Posts: 1484
Joined: Tue Mar 02, 2004 1:20 pm
Location: Amphibios 9

Re: UseOracleDatabase()

Post by Kiffi »

+1

That would be very useful

Greetings ... Kiffi
Hygge
IdeasVacuum
Always Here
Always Here
Posts: 6426
Joined: Fri Oct 23, 2009 2:33 am
Location: Wales, UK
Contact:

Re: UseOracleDatabase()

Post by IdeasVacuum »

+10 Very good idea 8)
IdeasVacuum
If it sounds simple, you have not grasped the complexity.
RomanR
User
User
Posts: 16
Joined: Wed Jul 11, 2012 3:54 pm

Re: UseOracleDatabase()

Post by RomanR »

+ 10 I need this feature very much 8) (ODBC is not convenient, TNSNAMES.ORA on Client-PCs available ...)
Michael42
User
User
Posts: 11
Joined: Thu Aug 30, 2012 3:12 am

Re: UseOracleDatabase()

Post 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
Michael42
User
User
Posts: 11
Joined: Thu Aug 30, 2012 3:12 am

Re: UseOracleDatabase()

Post 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
Michael42
User
User
Posts: 11
Joined: Thu Aug 30, 2012 3:12 am

Re: UseOracleDatabase()

Post by Michael42 »

Keep this feature request alive please.

Thanks.
User avatar
ts-soft
Always Here
Always Here
Posts: 5756
Joined: Thu Jun 24, 2004 2:44 pm
Location: Berlin - Germany

Re: UseOracleDatabase()

Post by ts-soft »

I don't think, pb will native support a LGPL Lib. Only Public Domain, MIT ...
PureBasic 5.73 | SpiderBasic 2.30 | Windows 10 Pro (x64) | Linux Mint 20.1 (x64)
Old bugs good, new bugs bad! Updates are evil: might fix old bugs and introduce no new ones.
Image
nicolaus
Enthusiast
Enthusiast
Posts: 456
Joined: Tue Aug 05, 2003 11:30 pm
Contact:

Re: UseOracleDatabase()

Post 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!
Michael42
User
User
Posts: 11
Joined: Thu Aug 30, 2012 3:12 am

Re: UseOracleDatabase()

Post 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
IdeasVacuum
Always Here
Always Here
Posts: 6426
Joined: Fri Oct 23, 2009 2:33 am
Location: Wales, UK
Contact:

Re: UseOracleDatabase()

Post 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!
IdeasVacuum
If it sounds simple, you have not grasped the complexity.
byo
Enthusiast
Enthusiast
Posts: 635
Joined: Mon Apr 02, 2007 1:43 am
Location: Brazil

Re: UseOracleDatabase()

Post by byo »

+100000

Please Fred & freak, add this.
If you need help with it please let me know.
But please make it happen. :-)
Proud registered Purebasic user.
Because programming should be fun.
nicolaus
Enthusiast
Enthusiast
Posts: 456
Joined: Tue Aug 05, 2003 11:30 pm
Contact:

Re: UseOracleDatabase()

Post by nicolaus »

@ Fred & freak

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

Thanks,
Nico
Last edited by nicolaus on Tue Aug 05, 2014 12:15 pm, edited 1 time in total.
Fred
Administrator
Administrator
Posts: 18153
Joined: Fri May 17, 2002 4:39 pm
Location: France
Contact:

Re: UseOracleDatabase()

Post 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.
nicolaus
Enthusiast
Enthusiast
Posts: 456
Joined: Tue Aug 05, 2003 11:30 pm
Contact:

Re: UseOracleDatabase()

Post 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.
Post Reply