Please , 
I canīt show the results of this procedure... 


STR_SELECT := STR_SELECT || ' AND EMP.EMP_CODIGO > ' || INICIO || ' AND 
ROWNUM < (SELECT PAR_VALOR FROM PAR WHERE PAR_DESCRICAO = ' || VALOR 
|| ')'; 

CURSOR1 :=DBMS_SQL.OPEN_CURSOR; 
DBMS_SQL.PARSE(CURSOR1,STR_SELECT,2); 
ROW_PROC :=DBMS_SQL.EXECUTE(CURSOR1); 
DBMS_SQL.CLOSE_CURSOR(CURSOR1); 

END PROC_CAT_SEL_EMPRESAS_TEMP; 


$cursor_1 = $dbase->newcursor(); 
$busca = $dbase->parse("BEGIN TESTE1.PROC_CAT_SEL_EMPRESAS_TEMP
('$emp_codigo','$razao_social','$cgc_empresa','$cat_pai','$cep','$cidade','$
estado','$sel_homologado_mol','$sel_homologado_emp','$ramo','$inicio',:resul
t);END;"); 
$dbase->bind_cursor("result",&$cursor_1); 
$dbase->execute(); 
$dbase->exec($cursor_1); 
$result_1 = $dbase->query_cursor($cursor_1); 
$codigo_emp = $result_1["EMP_CODIGO"]; 
$emp_razao = $result_1["EMP_RAZAO"]; 
$homologado_empresa = $result_1["HOMOLOGADO_EMPRESA"]; 
$homolgado_mol = $result_1["HOMOLOGADO_USEMOL"]; 
$catalogo = $result_1["CATALOGO"]; 
unset ($cursor_1); 

Thanks for any help, 
Ravage

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to