OCI - service handle not initialized

shashikant

hi all
i am facing of this error.What do you mean by this error and how to solved this error
some time my web page running fine but some time is showing this error.
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324: service handle not initialized in /opt/snpsweb2.0/htdocs/vigilguard/left_oracle.html on line 48

can anyboudy help me.
thanks
shashikant

bradgrafelman

In the future, please start a new thread instead of 'hijacking' others'. I've already moved your post into a new thread for you.

Having said that, it would probably help the DB guru's here immensely if you show us some of your code, e.g. a snippet of line 48 and a few lines of code surrounding that line (or other applicable areas, ex. the line(s) you connect to the DB server, etc.).

EDIT: In addition to thread hijacking, please do not post the same question across multiple threads/forums/etc.

shashikant

hi horizon,

hear is my cod......

get the records from the buInfo table

$result = OCIParse($dbcnx, "select buName,buId from buInfo order by buName");

if (!$result) {
echo("Error performing query: " . var_dump( oci_error() ) . "");
exit();
}

OCIExecute($result);

if (!$result) {
echo("Error performing query: " . var_dump( oci_error() ) . "");
exit();
}

OCIExecute($result);

if (!$result) {
echo("Error performing query: " . var_dump( oci_error() ) . "");
exit();
}

thanks
shashikant

bradgrafelman

I've moved your post to this thread (the one I created for you). Again, please stop posting the same question in multiple topics across the board.