[PHP-DB] Can't get record structure from Oracle - Pl/Sql

[Csillag Zsolt]

Hi,

I can't get the record structure from Pl/Sql in Php.
I have the following simple package:


create or replace package FirstTry is

 TYPE T_PROBA IS RECORD
     (
       Cegnev CegAdat.Cegadat_Cegnev%Type
       );


  Function Proba Return T_PROBA  ;

end FirstTry
/
create or replace package body FirstTry is

Function Proba Return T_PROBA Is
Vissza T_PROBA ;
Begin

  Vissza.Cegnev := 'Some Text Here' ;



  Return Vissza ;

End Proba;


end FirstTry
/


Now I want to run this FirstTry.Proba from Php so as to get this  'Some Text
Here'  text:


<?php

  print ' PL/SQL record import <br> <br> <br>' ;

  $db = "my_database";
  $Kapcsolat = ocilogon("scott","tiger",$db);

  $sql = "Begin :Rekord := scott.FirstTry.Proba ; End;" ;

  $Lekerdezes = ociparse($Kapcsolat,$sql);

   Class RekordTipus   //Here I tried everything, even arrays
   {
    Var $Cegnev = "x" ;
   }

  $Rekord = new RekordTipus()  ;


  OCIBindByName($Lekerdezes, ":Rekord", $Rekord);  // <-- Here I get the
error message, that the type is different


  ociexecute($Lekerdezes,OCI_DEFAULT);



print ' PL/SQL record import END' ;

?>


Please help me, if you can!

Thank you in advance

Zsolt Csillag,
Hungary


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php