Thứ Ba, 28 tháng 12, 2010

Error: {"OCI-22303: type \"{SCHEMA}\".\"{UDTTYPE}\" not found"}

To resolve the error You have to:

- Use UPPERCASE for your type: for example "VIBRIP.PRODUCTNESTEDTABLE" where VIBRIP is schema name and PRODUCTNESTEDTABLE is your type name

- Grant execute on your type for the user you are connected to Oracle

GRANT EXECUTE ON PRODUCTNESTEDTABLE TO user;

where user is the user that should access the type.

ORA-06550, PLS-00306: wrong number or types of arguments in call to…

Hi There,
I think that I can help you somewhere because I got this problem. I'm working with oracle 10g and VB.NET 2008.
I was stucked since 3 weeks searching the resolution for this kind of error.
Fortunately, I've resolved it today.
It's very dummy I think but it worked lool.
You have to pass all your OUT parameters in right order fiirst before that those of IN ones.
cmd.Parameters.Add("p_task_id", OracleDbType.Int32).Direction = ParameterDirection.Output;
and then
cmd.Parameters.Add("p_task_status", OracleDbType.Varchar2).Direction = ParameterDirection.Input;
cmd.Parameters["p_task_status"].Value = TaskStatus.COMPLETED;
That's it I think.
Hope this will help you.
Viele Glück.
Walid

Reference