Error with oracle recordset looping

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

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
Post Reply