| Passing the Collection Type as argument in procedure for oracle 10g R2 [message #356559] |
Fri, 31 October 2008 03:14  |
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
|
Senior Member |
|
|
There are two schema s1 and s2
in both schema,code(all packages) are same.
when we pass nested table as the argument to the procedure from front end(java layer),for s1 schema it is working fine.
but for the s2 schema,it is giving the error that
"wrong number of argument or types is passing"
but the type is same for both schema.
i give the code,
create or replace type abc1 as object(occ_code varchar2(14),
version number(6));
create or replace type abc2 as table of abc1;
suppose theere is packsge pkg1 and under package,one procedure is there pr_delete
procedure pr_delete(username varchar2,
grpid varchar2,
nes_abc abc2);
when we call the procedure pr_delete from front end(java layer),for s1 schema it is working fine.
but for the s2 schema,it is giving the error that
"wrong number of argument or types is passing"
|
|
|
|
|
|
| Re: Passing the Collection Type as argument in procedure for oracle 10g R2 [message #356569 is a reply to message #356562] |
Fri, 31 October 2008 03:55  |
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
|
Senior Member |
|
|
There are two schema s1 and s2
in both schema,code(all packages) are same.
when we pass nested table as the argument to the procedure from front end(java layer),for s1 schema it is working fine.
but for the s2 schema,it is giving the error that
"wrong number of argument or types is passing"
but the type is same for both schema.
i give the code,
create or replace type abc1 as object(occ_code varchar2(14),
version number(6));
create or replace type abc2 as table of abc1;
suppose theere is packsge pkg1 and under package,one procedure is there pr_delete
procedure pr_delete(username varchar2,
grpid varchar2,
nes_abc abc2);
when we call the procedure pr_delete from front end(java layer),for s1 schema it is working fine.
but for the s2 schema,it is giving the error that
"wrong number of argument or types is passing"
previously it is coming internal error
but after giving the all privileges to s2
(grant all privileges to s2)
the new error is coming
"wrong number of argument or types is passing"
|
|
|
|
|
|
| Re: Passing the Collection Type as argument in procedure for oracle 10g R2 [message #356577 is a reply to message #356569] |
Fri, 31 October 2008 05:06 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| ORAGENASHOK wrote on Fri, 31 October 2008 09:55 |
previously it is coming internal error
but after giving the all privileges to s2
(grant all privileges to s2)
the new error is coming
"wrong number of argument or types is passing"
|
If you changed the privs for user s2 and the error changed, it looks like the java call is ok, but a call within the called PL/SQL module is wrong..
Unfortunately, since you didn't post any code, it is of course just a guess.
[Updated on: Fri, 31 October 2008 05:06] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
