Re: Executing a PL/SQL Function

Does the database user your logging in as have execute permissions for that procedure? "Marcelo Dias de Toledo" <marcelo@nweb.com.br> wrote in message news:3AEDEB7D.5157B854@nweb.com.br... > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >