Error with oracle recordset looping

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
g_bhagirath
Forum Newbie
Posts: 3
Joined: Fri Nov 01, 2002 8:56 am

Error with oracle recordset looping

Post by g_bhagirath »

Hi All,
I am new to PHP and at my work we have recently upgraded apache on one of our box and the PHP pages on this server are now running into one perticular type of error.
Below is the error that it is throwing out:
Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /home/apache/https-drscholls/docs/adodb/adodb-oci8.inc.php on line 120

Fatal error: Call to a member function on a non-object in /home/apache/https-staging2/docs/browse/index.php on line 73
Here is the code from where the error is comming

Code: Select all

49 $cat_ID = $HTTP_GET_VARSї"ailID"];
50 include($app_root . 'browse/cls_browse.php');
51 $obj_template = new Template($app_root . "/browse");						// create a template object named $obj_template
52 $obj_browse	= new browse; 													// create a browse object named $obj_browse

53 $obj_template->set_file("page", "browse_ailment.html"); 					// set page = our template file
54 $obj_template->set_block("page", "myblock", "rows"); 
55 $obj_browse->ailment($cat_ID);
56 $obj_template->set_var("category", $obj_browse->cat_Name);
57 $obj_template->set_var("back_link", "problem.html");
58 $obj_template->set_var("header_pic", "0problem/hd_gotaprob.gif");
59 $obj_template->set_var("sub_header_pic", "");
60 $obj_template->set_var("bubble_boy", $obj_browse->cat_ShortName);
61 $obj_template->set_var("nav_play_img", "../0images/subnav_play.gif");
62 $obj_template->set_var("nav_spa_img", "../0images/subnav_spa.gif");
63 $obj_template->set_var("nav_preg_img", "../0images/subnav_preg.gif");
64 $obj_template->set_var("cat_Desc", $obj_browse->cat_Desc);
65 $obj_template->parse("output", "page", true);								// Append copies of mainpage:
66 while (!$obj_browse->rs->EOF) {
67 $obj_template->set_var("prod_name", $obj_browse->rs->fieldsї1]);		// Set element's value and name:
68 $obj_template->set_var("prod_descrip", $obj_browse->rs->fieldsї2]);
69 $obj_template->set_var("prod_img", $obj_browse->rs->fieldsї3]);
70 $obj_template->set_var("prod_link", "?fuseaction=product&prodID=".$obj_browse->rs->fieldsї0]."&type=ail&ID=".$obj_browse->cat_ID."&prodName=".$obj_browse->rs->fieldsї4]);
71 $obj_template->parse("rows", "myblock", true);							// Append copies of myblock:
72 $obj_browse->rs->MoveNext();
73 }
74 $obj_template->pparse("output", "page");
Since i am new to PHP i am unable to fine the place where its breaking in the code. The version of PHP that its running on is 4.0 .

Can some one help me with this.
Will appreciate any help..

Thanks in advance
Bhagirath
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

take a look at the user contributed note from tobias.fritz@gmx.net at http://vip2.alfanet.wroclaw.pl/system-d ... f.oci8.php
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Please don't cross-post (ie. do not post the same question in more than one forum) it gets confusing for everyone.

Mac
Post Reply