ORACLE - PHP - ociexecute problem ? HELP

Hello Ewerybody

Simple question regarding Php and Oracle built on RedHat

this works great !

//------------------------------------------

  ociexecute($stmt);
    while (ocifetch($stmt))
{

    $a=ociresult($stmt,"KOD_P");
     echo "$a<br>";
}

//------------------------------------------

but This one - doesent work !!!! ( look at the query !!!) note - this query works great under PL/SQL DEVELOPER

//------------------------------------------

$wer="select cen_detal('021076', 'A', 'CN', 'B', 1, 'PLN') as KOD_P from
dual;";

$stmt = ociparse($conn, $wer);

  ociexecute($stmt);
    while (ocifetch($stmt))
{

    $a=ociresult($stmt,"KOD_P");
     echo "$a<br>";
}

//----------------------------------------------

SERWER - RESPONSE Warning: ociexecute(): OCIStmtExecute: ORA-00911: invalid character in /usr/local/apache/htdocs/dual.php on line 36

Warning: ocifetch(): OCIFetch: ORA-24374: define not done before fetch or execute and fetch in /usr/local/apache/htdocs/dual.php on line 38

What's the diferent between queries and how to execute the query like that - maby ociparse don't understand this one ???

HELP !
regards from Poland Received on Fri Mar 19 2004 - 05:36:16 CST