running pl/sql from php

chintito

Hi all,
I am trying to run a pl/sql block from php script.But it generates a warning:
Warning: oci_execute() [function.oci-execute]: ORA-00900: invalid SQL statement in D:\Program Files\Apache Group\Apache2\htdocs\test2.php on line 42

here is my php code:

Expand|Select|Wrap|Line Numbers

 
<?php

$con = oci_pconnect('SCOTT','TIGER');

$sql = "DECLARE"

."v_Image BLOB;"

."v_BFile BFILE :=

BFILENAME('LOB_DIR','earthrise_500.jpg');"

."v_Title VARCHAR2(100);"

."v_OffSetIn INTEGER := 1;"

."v_OffSetFrom INTEGER := 1;"

."BEGIN"

."INSERT INTO blob_tab (id,blo) VALUES (5,EMPTY_BLOB());"

."SELECT blo"

."INTO v_image"

."FROM blob_tab WHERE id = 5;"

."DBMS_LOB.OPEN(v_BFile, DBMS_LOB.LOB_READONLY);"

."DBMS_LOB.OPEN(v_Image, DBMS_LOB.LOB_READWRITE);"

."DBMS_LOB.LOADFROMFILE(v_Image, v_BFile, DBMS_LOB.GETLENGTH(v_BFile),"

."v_OffSetIn, v_OffSetFrom);"

."DBMS_LOB.CLOSE(v_Image);"

."DBMS_LOB.CLOSE(v_BFile);"

."END;";

$stid = oci_parse($con,$sql);

if (!oci_execute($stid, OCI_DEFAULT))

{

oci_rollback($con);

die ("Error saving BLOB\n");

}

oci_commit($con);

oci_close($con);

}

}

?>

when i run the pl/sql part, it goes well without showing any warning.
am i missing something?plz help..thanks in advance....

bergy

It really helps us read your code if you put [ code=php ] ....code.... [ /code ] around your code. You do get a warning, but does the SQL statement actually run anyway on your database anyway? If so just put an @ sign in front of the function causing the warning and you won't see it any more.

pbmods

Heya, chintito. Welcome to TSDN!

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

running pl/sql from php

re: running pl/sql from php

re: running pl/sql from php

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about