Executing a PL/SQL Function

From: 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

« previous php.db (#8999) next »