Execute procedure error (Native SQL)

rodrigo_paisante3 — Tue, 17 Jul 2007 14:47:18 GMT

Hi experts,

I create a procedure

EXEC SQL.

create or replace procedure update_zsmadiprinc

is begin

( p_codigo in number(5),
p_ano in varchar2(4),
p_doc_vlr_princ in varchar2(10)
p_subrc out number ) is begin
update T_INTERF_RESSARC_FORNEC_R3
set ano_doc = p_ano,
NUM_DOC_VALOR_PRINC = p_doc_vlr_princ,
where cod_interf_ressarc_fornec_r3 = p_codigo;
if sql%found then
p_subrc := 0;
else
p_subrc := 4;
end if;

end;

ENDEXEC.

and execute it

EXEC SQL.

execute procedure update_zsmadiprinc

(in :wa-cod_interf,
in :wa-ano_doc,
in :wa-num_doc_valor_princ,
out :vg_subrc)

ENDEXEC.

But when i execute the procedure, shows dump error:

Database error text........: "ORA-06550: line 1, column 7:#PLS-00905: object

UPDATE_ZSMADIPRINC is invalid#ORA-06550: line 1, column 7:#PL/SQL:

Statement ignored#"

Triggering SQL statement...: "CLOSE "

Internal call code.........: "[DBDS/NEW DSQL]"

Please check the entries in the system log (Transaction SM21).

I comment all source, and the error is the same.

When i create the procedure, no erros are show.

I changed the name of the procedure, the type of parameters, and now i comment all and the error always is the same!!!! Can you help me!!! I need to finish this urgently!

Thanks in advance

Message was edited by:

Re: Execute procedure error (Native SQL)

Former Member — Tue, 17 Jul 2007 14:58:54 GMT

How your are accessing Oracle Database through DBLINK or anyother way. Kindly check the statement which link Oracle Database.

Re: Execute procedure error (Native SQL)

rodrigo_paisante3 — Wed, 18 Jul 2007 11:11:32 GMT

It is not possible to create a procedure, then, i just execute sql direct.

thanks

topic Re: Execute procedure error (Native SQL) in Application Development and Automation Discussions

Execute procedure error (Native SQL)

Re: Execute procedure error (Native SQL)

Re: Execute procedure error (Native SQL)