From owner-freebsd-questions@FreeBSD.ORG  Wed Jul  1 21:57:41 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 7227E106564A
	for <freebsd-questions@freebsd.org>;
	Wed,  1 Jul 2009 21:57:41 +0000 (UTC)
	(envelope-from martin@dc.cis.okstate.edu)
Received: from dc.cis.okstate.edu (dc.cis.okstate.edu [139.78.103.93])
	by mx1.freebsd.org (Postfix) with ESMTP id 44DE18FC17
	for <freebsd-questions@freebsd.org>;
	Wed,  1 Jul 2009 21:57:40 +0000 (UTC)
	(envelope-from martin@dc.cis.okstate.edu)
Received: from dc.cis.okstate.edu (localhost.cis.okstate.edu [127.0.0.1])
	by dc.cis.okstate.edu (8.14.2/8.13.8) with ESMTP id n61LvUgn094165
	for <freebsd-questions@freebsd.org>;
	Wed, 1 Jul 2009 16:57:30 -0500 (CDT)
	(envelope-from martin@dc.cis.okstate.edu)
Message-Id: <200907012157.n61LvUgn094165@dc.cis.okstate.edu>
To: freebsd-questions@freebsd.org
Date: Wed, 01 Jul 2009 16:57:30 -0500
From: Martin McCormick <martin@dc.cis.okstate.edu>
Subject: Oracle, php and a Fog of Confusion oci_connect
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 01 Jul 2009 21:57:41 -0000

I have a fragment of php code which connects to an external
Oracle data base. It looks mostly like:

   <?php
   //open connection to database
   $conn = oci_connect("db_name", "PASS_WORD",
   "host.name.OKSTATE.EDU");
     if (!$conn) {
      $e = oci_error();
      print htmlentities($e['message']);
      exit;
     }
   ?>

	We have had php5 installed on the system in question for
a couple of years and just successfully installed
linux-oracle-instantclient-sqlplus.

	The info from php says it understands shared libraries.

	If I run the code fragment via php using a script
starting with
#! /usr/local/bin/php

I get
#
Fatal error: Call to undefined function oci_connect() in /usr/home/martin/tmp/qtest on line 4

I am not terribly surprised since, unless a shared library
changed, php is the same old php we have had all this time.

	Basically, I am confused as to what I need to do next to
weld the tail on the donkey.:-) Somehow, this all has to fit
together to produce the connection to the Oracle server.

	The linux-oracle-instantclient-sqlplus  pkg-descr file
says:

Oracle instant client - SQLPlus distribution

Instant Client allows you to run your applications without installing
the standard Oracle client or having an ORACLE_HOME.  OCI, OCCI, ODBC,
and JDBC applications work without modification, while using
significantly less disk space than before.  Even SQL*Plus can be used
with Instant Client.  No recompile, no hassle.

	Any suggestion? Obviously the php application hasn't
gotten wind of the instantclient yet.

Martin McCormick
Systems Engineer
405 744-7572   Stillwater, OK
Information Technology Department
Telecommunications Services Group