Hello everyone,
I just installed Zend Core 2.5.0 (simply apache + php 5) with oracle
instant client. I enabled the oracle extension. Everything works ok, but
I ran into one strange problem.
I can connect to the oracle server without problems, I can also perform
SELECTs,INSERTs, etc. The problems start when I try to execute a PL/SQL
script. E.g.
Lets have these 2 oracle tables.
CREATE TABLE TABLE_A
(
AID NUMBER,
ADATA VARCHAR2(255 BYTE)
)
CREATE TABLE TABLE_B
(
BID NUMBER,
AID NUMBER,
BDATA VARCHAR2(255 BYTE)
)
INSERT INTO TABLE_A (AID) VALUES (0)
INSERT INTO TABLE_B (BID) VALUES (0)
lets try to execute very simple PL/SQL
DECLARE AAID NUMBER;
BEGIN
SELECT MAX(AAID)+1 INTO AAID FROM TABLE_A;
INSERT INTO TABLE_A (
aid,adata)
VALUES (
AAID
, 'table_a data');
INSERT INTO TABLE_B (
bid,
aid,bdata)
VALUES (
(SELECT MAX(bid)+1 FROM TABLE_B)
,AAID
, 'table_b data');
END;
I can execute this script through TOAD or using simple Java script. But
if I try to execute this script using the next php on the Zend Core, I
get this warning.
Quote:
PHP Warning: oci_execute(): ORA-06550: line 1, column 21:
PLS-00103: Encountered the symbol "" when expecting one of the
following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor in C:\Program
Files\Zend\Apache2\htdocs\coreLib\get_event_itm\test.php on line 21
Here is the very simplified code I'm using
<?php
error_reporting ( E_ALL );
$link = oci_connect("USER","PASSWORD","HOST");
$query = "DECLARE AAID NUMBER;
BEGIN
SELECT MAX(AAID)+1 INTO AAID FROM TABLE_A;
INSERT INTO TABLE_A (
aid,adata)
VALUES (
AAID
, 'table_a data');
INSERT INTO TABLE_B (
bid,
aid,bdata)
VALUES (
(SELECT MAX(bid)+1 FROM TABLE_B)
,AAID
, 'table_b data');
END;";
$result = oci_parse ( $link, $query );
$status = oci_execute ( $result );
?>
Note: When I deployed this script onto the production server, running
php5 on RH4, it finnished without problems.
To be honest, I don't even have an idea where the problem can be. I
would be very thankful for any suggestions.
thank you
Martin
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
