Re: OCISessionBegin: Error while trying to retrieve text for error ORA-12705 in /....

heoseong wrote:
>
> <?php
> /* OCIDefineByPos example thies_at_digicol.de (980219) */
> $db="(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = CP)(HOST =
> csedu1)(PORT = 1521))) (CONNECT_DATA = (SID = RCL)))";
> $conn = OCILogon("scott","tiger",$db);
> $stmt = OCIParse($conn,"select empno, ename from emp");
> /* the define MUST be done BEFORE ociexecute! */
> OCIDefineByName($stmt,"EMPNO",&$empno);
> OCIDefineByName($stmt,"ENAME",&$ename);
> OCIExecute($stmt);
> while (OCIFetch($stmt)) {
> printf("number:".$empno."<br>");
> printf("name:".$ename."<br>");
> }
> OCIFreeStatement($stmt);
> OCILogoff($conn);
> ?>
> -----------------------------------------------------------
> Warning: OCISessionBegin: Error while trying to retrieve text for error
> ORA-12705 in /home/oracle/public_html/oracle2.php on line 4
>

Is this a question?

If yes: The answer might be: Probably you Oracle environment within the contect of your web server is wrong. I guess ORACLE_HOME is not set.

You can check this with a dummy CGI script which outputs your environment.

Uwe

-- 
Uwe Schneider - WEB.DE AG  - Amalienbadstr. 41  - 76227 Karlsruhe 
F&E / Database & Software Technologies - Tel. (+49) 721 94329 8320