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




Reply via email to