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:[EMAIL PROTECTED]
Phone: 55 71 341-8474 - Fax: 55 71 341-8480
--
PHP General 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]
