Home » SQL & PL/SQL » SQL & PL/SQL » nested tables (split from hijacked thread)
nested tables (split from hijacked thread) [message #290323] Fri, 28 December 2007 06:38 Go to next message
amitmohangupta
Messages: 9
Registered: April 2007
Location: India
Junior Member

i defined a type in a package specification and i want to get the column in that type how can i gwet that
Re: nested tables [message #290331 is a reply to message #290323] Fri, 28 December 2007 06:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
SQL does not know PL/SQL type.
You have to define a real type with "create type" statement.

Regards
Michel
Re: nested tables [message #290335 is a reply to message #290331] Fri, 28 December 2007 06:58 Go to previous messageGo to next message
amitmohangupta
Messages: 9
Registered: April 2007
Location: India
Junior Member

ANY TABLE WHICH CAN GIVE ME THIS INFORMATION
Re: nested tables [message #290342 is a reply to message #290335] Fri, 28 December 2007 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ DON'T POST IN UPPER CASE

2/ Is this a question? And which information are you talking about?

Regards
Michel
Re: nested tables [message #290347 is a reply to message #290342] Fri, 28 December 2007 07:32 Go to previous messageGo to next message
amitmohangupta
Messages: 9
Registered: April 2007
Location: India
Junior Member

I think we can use DBMS_DESCRIBE.DESCRIBE_PROCEDURE Procedure. But I need an example for that please.

Re: nested tables [message #290360 is a reply to message #290347] Fri, 28 December 2007 09:08 Go to previous message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can use it.
Oracle provides it to use it.
It even gave an example of its use in the documentation.

Regards
Michel

[Updated on: Fri, 28 December 2007 09:09]

Report message to a moderator

Previous Topic: UTL_FILE
Next Topic: Problem with selecting distinct values
Goto Forum:
  


Current Time: Thu Dec 08 06:21:00 CST 2016

Total time taken to generate the page: 0.08295 seconds