--==New Window==--

[Anon]

how may i type my login and pass in a Html form and then in the time to submit the same send the value of login and pass to a new window wich will open myphp files??The problem is that when the new window is opened nothing appears.....WHY?

[Anon]

pls help me out i got this error its veru urgunt.

my php script is proper here belove:

<?php
2 PutEnv("$ORACLE_SID=oracle");
3 echo "DEBUG:--->connecting oracle<BR>";
4 echo "DEBUG:--11111--------------------------<><BR>";
5 $connection = OCILogon("system","manager");
6 if ($connection == false){
7 echo "DEBUG:------2222----------------------<><BR>";
8 echo OCIError($connection).":".OCIError($connection)."<BR>";
9 exit;
10 }
11
12
13 $query = "insert into emp values ('ppp','pa')";
14 $cursor = OCIParse($connection, $query);
15 if ($cursor == false){
16 echo OCIError($cursor).":".OCIError($cursor)."<BR>";
17 exit;
18 }
19
20 $result = OCIExecute($cursor);
21 if ($result == false){
22 echo OCIError($cursor).":".OCIError($cursor)."<BR>";
23 exit;
}
11
12
13 $query = "insert into emp values ('ppp','pa')";
14 $cursor = OCIParse($connection, $query);
15 if ($cursor == false){
16 echo OCIError($cursor).":".OCIError($cursor)."<BR>";
17 exit;
18 }
19
20 $result = OCIExecute($cursor);
21 if ($result == false){
22 echo OCIError($cursor).":".OCIError($cursor)."<BR>";
23 exit;
24 }
25
26 OCICommit($connection);
27 OCILogoff($connection);
28
29 echo "DEBUG:--->insert sucessfully in oracle<BR>";
30 ?>

what is the probelm no buby know some says
modify listner.ora some say modify tnslsnr.ora so

exacly what is the solution anybody know than pls send me

thaks

vishal

[Anon]

Try this it will work

 putenv("ORACLE_SID='$sid'");
$this->connect_id = OCILogOn($user, $password, "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.66.98)(PORT = 15210))) (CONNECT_DATA = (SID = SOL)))");
 if( $this->connect_id )
    return $this->connect_id;
 else
    return FALSE;

[Anon]

Good lord almighty you are my savior!

I wrestled with this problem for about 5 hours until I stumbled on this option. Worked right off the bat.

[Anon]

A variant of this worked for me when I got the tsnmes.ora error message. I just copied the description of the connection that I wanted to use from the tnsnames.ora file into a variable $description, and logged on with

$connection=OCILogon("myusername","mypassword", "$description");

I knew the connection was ok because sqlplus worked. Maybe some problem with putenv("ORACLE_HOME=path" ). The environmental variable. ORACLE_HOME was not needed with the above method.