Re: [Phplib-users] Oracle usage

[Jesse S. <ph...@sw...>]

Bind variables is one of the features that has not been address by DB_SQL.
There is a quagmire of problems that need to be address by bind variables,
i.e.; scalar(like you have implemented); two arrays in a matched set, one
with variables the other the values; a hash of variable=>value or a function
that loads the array.

It becomes a challenge to address these issues.  All of them are of some
value, but unless you are using blobs, like in Mike's case, standard insert,
update, delete, select works fine.

> From: Mike Green <Mik...@sa...>
> Organization: SaeSolved::
> Date: Mon, 24 Sep 2001 10:51:17 -0700
> To: er...@pa...
> Cc: "php...@li..."  <php...@li...>
> Subject: Re: [Phplib-users] Oracle usage
> 
> Eric,
> 
> About a year ago I ran into a problem with Oracle and PHPLib. The patch
> that I came up with after discussions with those on this list was posted
> to the list on 12 October 2000. (I will paste the same post to the end of
> this for your convenience.) Other than that I had no problems.
> 
> The project then died when the firm for which I was doing the work
> declared bankruptcy in January of 2001. This was after what I had
> implemented had been well tested on a prototype basis, but before the web
> site went into full production. I can't remark, therefore, on whether
> there were any problems in the longer term or under high load conditions.
> 
> The text of what I posted on 12 October 2000:
> 
> "Well, with the suggestions here and those posted on the PHP manual pages
> for OCI8 (especially those of jc...@id... on the page
> http://www.php.net/manual/function.ocinewdescriptor.php), I've come up
> with something that seems to be working.  I thought it would be good to
> post it here in case someone else can use it ...and to get your feedback.
> 
> "I've extended the OCI8 DB_Sql class (db_oci8.inc,v 1.4 2000/07/12
> 18:22:34) by revising its function query to read:
> 
> function query($Query_String, $bind_var = '', $bind_val = '') {
> 
> /* No empty queries, please, since PHP4 chokes on them. */
> if ($Query_String == "")
> /* The empty query string is passed on from the constructor,
> * when calling the class without a query, e.g. in situations
> * like these: '$db = new DB_Sql_Subclass;'
> */
> return 0;
> 
> $this->connect();
> 
> if ($bind_var){
> $clob = OCINewDescriptor($this->Link_ID, OCI_D_LOB);
> $Query_String .= " returning $bind_var into :the_blob";
> }
> 
> $this->Parse=OCIParse($this->Link_ID,$Query_String);
> if(!$this->Parse) {
> $this->Error=OCIError($this->Parse);
> } else {
> if ($bind_var) {
> OCIBindByName($this->Parse, ':the_blob', &$clob, -1,
> OCI_B_CLOB);
> OCIExecute($this->Parse, OCI_DEFAULT);
> if($clob->save($bind_val)){
> OCICommit($this->Link_ID);
> }else{
> $this->Error = "Couldn't insert CLOB into database.";
> }
> OCIFreeDesc($clob);
> } else {
> OCIExecute($this->Parse);
> }
> $this->Error=OCIError($this->Parse);
> }
> 
> $this->Row=0;
> 
> if($this->Debug) {
> printf("Debug: query = %s<br>\n", $Query_String);
> }
> 
> if ($this->Error["code"]!=1403 && $this->Error["code"]!=0 &&
> $this->sqoe)
> echo "<BR><FONT
> color=red><B>".$this->Error["message"]."<BR>Query:\"$Query_String\"</B></FONT>
> ";
> 
> return $this->Parse;
> }
> 
> "This seems to be working.
> 
> "It has three shortcomings that I am aware of:
> 
> "1) It only allows for one type of 'bind' variable: CLOB.
> 
> "2) It only allows for one column to be a 'bind' variable
> 
> "3) One must be sure that the $Query_String is has the correct form for
> this usage:  '$bind_var' in $Query_String must be paired with
> 'EMPTY_CLOB(),' not its value: $bind_val.
> 
> "I can think of ways to deal with each of these, but not in the time I
> have available to get the present project going.  And this seems to be
> doing the job for Inserts and Updates.
> 
> "I find it a bit puzzling that Selects seem to work all right without
> using this approach.  I.e. I'm just using a straight SQL select, without
> any 'binds.'  And I seem to be having no trouble retrieving the data. ..."
> 
> Cheers!
> 
> Mike Green
> 
> Eric McKeown wrote:
> 
>> Hi folks,
>> 
>> Just wondering how many of you out there have used PHP/PHPLIB with
>> Oracle and whether you've had good experiences.  I've been asked to
>> evaluate the possibility of moving an application that is currently
>> PHP/PHPLIB/Sybase to an Oracle backend, and if you have any gotchas to
>> share, I would greatly appreciate the info.
>> 
>> Thanks,
>> 
>> Eric
>> 
>> _______________________________________________
>> Phplib-users mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phplib-users
> 
> --
> Mike Green
> SaeSolved::
> http://www.saesolved.com
> http://www.everypeople.net
> http://www.sitewidgets.com
> http://www.widgetchuck.com
> 
> 
> 
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users