OraFAQ Forum: SQL & PL/SQL » Nested table as in parameter

Home » SQL & PL/SQL » SQL & PL/SQL » Nested table as in parameter (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Nested table as in parameter [message #633441]

Wed, 18 February 2015 14:08

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

Can i insert the nested table in parameter in procedure to table emp (id, name)

CREATE OR REPLACE PROCEDURE test_array(eid in EMP_ID,ename in EMP_NAME) is
   v_id EMP_ID := EMP_ID();
   v_name EMP_NAME:= EMP_NAME();
  BEGIN
  
  --Insert the values to employee table

    
  end test_array;

[Updated on: Wed, 18 February 2015 14:09]

Report message to a moderator

Re: Nested table as in parameter [message #633442 is a reply to message #633441]

Wed, 18 February 2015 15:03

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you FIRST feedback and thank people who helped you before posting a new question?
For myself, due to our bad behaviour, I refuse to help you more.

Report message to a moderator

Re: Nested table as in parameter [message #633444 is a reply to message #633442]

Wed, 18 February 2015 15:07

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

this are two separate QUESTION I AM TRYING TO GET ANS. i still not got the solution for any
Thanks for your feedback ..

Report message to a moderator

Re: Nested table as in parameter [message #633445 is a reply to message #633444]

Wed, 18 February 2015 15:19

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I wish I have one in your previous question where you got answers.
Of course, you have to make a little effort and not expect we provide you the complete code.

Also, can you post a complete question?
What is EMP_ID? What is EMP_NAME? Where is there any nested table in your post?
What is a nested table for you?
How is this different from your previous question?

Report message to a moderator

Re: Nested table as in parameter [message #633446 is a reply to message #633445]

Wed, 18 February 2015 16:20

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

CREATE OR REPLACE TYPE EMP_NAME IS TABLE OF VARCHAR2(4000)
CREATE OR REPLACE TYPE EMP_ID IS TABLE OF NUMBER

my question is whether/how we can read this type in procedure and than insert to emp table.

Report message to a moderator

Re: Nested table as in parameter [message #633448 is a reply to message #633446]

Thu, 19 February 2015 01:05

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In the same way than in your previous question.
Read the section about records and collections in the links I provided, you cannot guess a syntax, you have to read about it.
In short, you have to get the basics of the language before you can speak it.

Report message to a moderator

Re: Nested table as in parameter [message #633865 is a reply to message #633448]

Thu, 26 February 2015 10:09

manns
Messages: 59
Registered: March 2006
Location: Bangalore

Member

Thanks. i will work on this

Report message to a moderator

Previous Topic:	How do I use SQL column values as column names
Next Topic:	Using oracle object

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 25 21:17:02 CDT 2026