Home » SQL & PL/SQL » SQL & PL/SQL » dynamic collection set
dynamic collection set [message #444362] Sat, 20 February 2010 20:37 Go to next message
rags11
Messages: 21
Registered: October 2008
Junior Member
Hi,

I want to have a dynamic collection as a parameter to procedure.This collection should access dynamic column set.
Any idea how to achive this?

while calling this proc user may not aware of what column set is going to be sent to this proc.

Thanks for help
Re: dynamic collection set [message #444363 is a reply to message #444362] Sat, 20 February 2010 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Any idea how to achive this?
I am not sure I know what a "dynamic collection" is? (what URL?)
How does a dynamic collection differ from a static collection?
Exactly what makes your collection "dynamic"?

>while calling this proc user may not aware of what column set is going to be sent to this proc.

Exactly how does proc determine/know which column set it got?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 20 February 2010 22:58]

Report message to a moderator

Re: dynamic collection set [message #444381 is a reply to message #444362] Sun, 21 February 2010 06:00 Go to previous messageGo to next message
daizhicun
Messages: 6
Registered: February 2010
Location: china
Junior Member

I had made it .but it can not be called.
Re: dynamic collection set [message #444387 is a reply to message #444381] Sun, 21 February 2010 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How what you posted help us to know what is your problem?

And answer Tim Boles questions at
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=39362&SkipA=0

In both cases example have been asked, post it. Post what you've done. Post what you want.

Regards
Michel
Re: dynamic collection set [message #444389 is a reply to message #444387] Sun, 21 February 2010 06:31 Go to previous messageGo to next message
rags11
Messages: 21
Registered: October 2008
Junior Member
Hi Micheal,

I have replied Tim boles with the following information.

Sorry for the unclear question.

Actually,what i wanted is to build a procedure which accepts a collection where the values of the collection to have diffrent table data in it.
I have ten diffrent procedures for ten tables with the same code logic but every packge accepts its corresponding table information.
I want to have a generic procedure that will accept any of these ten table collections and processes the data.

Will xml processing in oracle will help my problem?

Thank you.
Re: dynamic collection set [message #444391 is a reply to message #444389] Sun, 21 February 2010 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not clear.
Post an example.

Regards
Michel

Re: dynamic collection set [message #444398 is a reply to message #444389] Sun, 21 February 2010 10:35 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I want to have a generic procedure that will accept any of these ten table collections and processes the data.

How will procedure know/determine for which table the data is to reside?
Re: dynamic collection set [message #444419 is a reply to message #444362] Sun, 21 February 2010 20:10 Go to previous messageGo to next message
rags11
Messages: 21
Registered: October 2008
Junior Member
>How will procedure know/determine for which table the data is to reside?

The talename we can send while calling the procedure,based on it we may use the corresponding object.

Re: dynamic collection set [message #444420 is a reply to message #444419] Sun, 21 February 2010 20:13 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be helpful if you provided expected/desired results & a detailed explanation how & why the test data gets transformed or organized.
Previous Topic: Full outer join
Next Topic: sum over multiple tables
Goto Forum:
  


Current Time: Sun Dec 04 04:24:16 CST 2016

Total time taken to generate the page: 0.11095 seconds