Select/Where with parameter does not work on Oracle

Question

Select/Where with parameter does not work on Oracle

Asked 6 years, 7 months ago

Viewed 512 times

0

I am making a select with Where via PHP and Oracle, when it receives an error by the parameter occurs:

Warning: oci_execute(): ORA-00911: invalid Character in C: xampp htdocs project includes Read.php on line 52 Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in C: xampp htdocs projeto index.php on line

If I pass the direct parameter works normally, as commented line, it works.

public function readAnexos($CDLICITACAO) {

    try{
        //$id = '012103';
        $id = $CDLICITACAO;

            $sql_query = "SELECT * FROM TBLICITCAO WHERE CDLICITACAO = $id";
            $stid = oci_parse($this->db, $sql_query);

            oci_execute($stid);
            return $stid;

        }

    catch (Exception $e){
        echo $e->getMessage() . "<br>Error na linha:  ";
        echo "<b>" . $e->getTraceAsString()."</b>";
        parent::fechar();
    }
}

2 answers

Browser other questions tagged php oracle select where

You are not signed in. Login or sign up in order to post.

by David Alves • **2,470** points · Answer 1 · 2018-04-13T13:15:25+00:00

0

The problem is in the identification of $id, is not passing the variable but string '$id' to be compared with a probably whole field.

To solve your problem replace the query line with:

$sql_query = "SELECT * FROM TBLICITCAO WHERE CDLICITACAO = ".$id;

(80) "SELECT * FROM TBLICITCAO WHERE CDLICITACAO = 014384" Warning: oci_execute(): ORA-00911: invalid Character in C: xampp htdocs project includes Read.php on line 48 Warning: oci_fetch_array(): ORA-24374: sets not done before fetch or execute and in C:xampp htdocs project index.php on line 72

– Andre C

2018/04/13 at 13:18
Code for lines 48 and 72?

– David Alves

2018/04/13 at 13:25
Read.php oci_execute($stid); index.php while ($Row = oci_fetch_array($stid)) {
 $dataAnexos[] = array("IDANEXO" => $row['IDANEXO'],
 "CDLICITACAO" => $row['CDLICITACAO'],
 "NARQUIVO" => $row['NARQUIVO'],
 "DIRARQUIVO" => $row['DIRARQUIVO']);
}

– Andre C

2018/04/13 at 13:28
@Andrec Is the name of the table (TBLICITACAO) and the name of the field (CDLICITACAO) higher in the bd? If they are minute, try going to minuscule in php and see if something changes.

– David Alves

2018/04/13 at 13:29
They are all uppercase... the funny thing is that only I change the $id = 013203 works... if I leave the parameter not... but the parameter is coming correctly tb. the column in the bank is VARCHAR2(6 BYTE)

– Andre C

2018/04/13 at 13:34

by Andre C • 1 point · Answer 2 · 2018-04-13T13:20:03+00:00

Even though it didn’t work, it generated an error... but the sql is correct, if I run it in the database, it works.

string(80) "SELECT * FROM TBLICITCAO WHERE CDLICITACAO = 014384"

Warning: oci_execute(): ORA-00911: invalid Character in C: xampp htdocs project includes Read.php on line 48

Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in C: xampp htdocs projeto index.php on line 72