ora_columntype

(PHP 3, PHP 4 , PHP 5)

ora_columntype -- Gets the type of an Oracle result column

Description

string ora_columntype ( resource cursor, int column)

Returns the Oracle data type name of the field/column column on the cursor cursor. Column 0 is the first column. The returned type will be one of the following:

"VARCHAR2"
"VARCHAR"
"CHAR"
"NUMBER"
"LONG"
"LONG RAW"
"ROWID"
"DATE"
"CURSOR"

($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x := 7.77; end;");
  
ora_bind($curs, "result", ":x", $len, 2);
  
ora_bind($curs, "input", ":in", 5, 1);
  
ora_bind($curs, "output", ":out", 5, 2);
  
$input = 765;
  
ora_exec($curs);
  echo
"Result: $result<br />Out: $output<br />In: $input";
?>