ORACLE dbms_sql - problems with select
| From: | Fernando Ferreras | Date: | Tue, 20 Feb 2001 16:23:10 +0000 |
| Subject: | ORACLE dbms_sql - problems with select | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6788@lists.php.net to get a copy of this message | ||
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