Home » SQL & PL/SQL » SQL & PL/SQL » Passing the Collection Type as argument in procedure for oracle 10g R2
Passing the Collection Type as argument in procedure for oracle 10g R2 [message #356559] Fri, 31 October 2008 03:14 Go to next message
ORAGENASHOK
Messages: 238
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 #356562 is a reply to message #356559] Fri, 31 October 2008 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So something is different.

Regards
Michel
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 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
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 #356572 is a reply to message #356569] Fri, 31 October 2008 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't access what you think you access.
As I said something must be different.

Regards
Michel
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 Go to previous message
Frank
Messages: 7880
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

Previous Topic: Query on Performace Issue
Next Topic: Table Variables
Goto Forum:
  


Current Time: Sat Dec 10 15:04:19 CST 2016

Total time taken to generate the page: 0.15254 seconds