Executing a PL/SQL Function
| From: | Marcelo Dias de Toledo | Date: | Mon, 30 Apr 2001 22:47:25 +0000 |
| Subject: | Executing a PL/SQL Function | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8999@lists.php.net to get a copy of this message | ||
Here is the code:
$stmt = OCIParse($conn,"BEGIN prontolog.pc_int.pedido(:p_cgc_lweb,
:p_id_cliente, :p_id_pedido, :p_id_transp, :p_contrato, :p_dt_emissao,
:p_dt_chegada, :p_dt_entrega, :p_vl_frete, :c_nome, :c_fone1, :c_fone2,
:c_fax, :c_email, :c_endereco_f, :c_bairro_f, :c_cep_f, :c_cidade_f,
:c_estado_f, :c_nome_e, :c_endereco_e, :c_bairro_e, :c_cep_e,
:c_cidade_e, :c_estado_e, :p_id_conpag, :v_observa); END;");
OCIBindByName($stmt, ":p_cgc_lweb", &$p_cgc_lweb, 150);
OCIBindByName($stmt, ":p_id_cliente", &$p_id_cliente, 150);
OCIBindByName($stmt, ":p_id_pedido", &$p_id_pedido, 150);
.
.
.
$p_cgc_lweb = "04284227000167";
$p_id_cliente = "29334988800";
$p_id_pedido = "0001";
$p_id_transp = "00926551000180";
$p_contrato = "numero do contrato da transportadora";
$p_dt_emissao = date("Y-m-d H:i:s");
$p_dt_chegada = date("Y-m-d H:i:s");
.
.
.
OCIExecute($stmt);
print "(($v_observa))";
prontolog is the schema
pc_int is the package
pedido is the function
And this is the exacly output
---//---
Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00221:
'PEDIDO' is not a procedure or is undefined ORA-06550: line 1, column 7:
PL/SQL: Statement ignored in /www/htdocs/mariamercado/teste.phtml on
line 64
(())
---//---
Can I execute functions ? If yes, what may be wrong ?
Thank you very much,
--
Marcelo Dias de Toledo
N-Web E-Commerce - http://www.nweb.com.br
mailto:marcelo@nweb.com.br
Phone: 55 71 341-8474 - Fax: 55 71 341-8480