Home » SQL & PL/SQL » SQL & PL/SQL » table type
table type [message #253528] Tue, 24 July 2007 03:21 Go to next message
xleigaj
Messages: 7
Registered: July 2007
Junior Member
Hi,

I've table of records and I want use it in two procedures. First procedure calls the second and I wanted use index table as parameter, but it isn't allowed. How can I solve problem. Both of procedure are in package. Can I global declare the table in package and then can I use values in it by both procedures?

Regards
xleigaj
Re: table type [message #253535 is a reply to message #253528] Tue, 24 July 2007 03:34 Go to previous messageGo to next message
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
Junior Member
Yes you have to declare table globally
Re: table type [message #253544 is a reply to message #253535] Tue, 24 July 2007 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can I global declare the table in package

Quote:
Yes you have to declare table globally

Laughing

Regards
Michel
Re: table type [message #253876 is a reply to message #253528] Wed, 25 July 2007 03:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

JAVE or C++
Re: table type [message #253883 is a reply to message #253876] Wed, 25 July 2007 03:54 Go to previous messageGo to next message
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
Junior Member
Michel but we can create a table in in DB ,using CREATE TYPE command
Re: table type [message #253884 is a reply to message #253883] Wed, 25 July 2007 03:57 Go to previous message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
CREATE TYPE creates a type not a table.
Unless you precise your question, gives an example and so on I don't think you will have more help.

Regards
Michel
Previous Topic: help with creating a delay in stored procedures
Next Topic: Query to find Duplicate set of values
Goto Forum:
  


Current Time: Sun Dec 08 19:05:50 CST 2024