Does the database user your logging in as have execute permissions for that
procedure?
"Marcelo Dias de Toledo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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 Database 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]
>
--
PHP Database 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]
