• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Global temporary table

 
Minni Sharma
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

my requirement is ...that i need a stored procedure which will create a global temporary table with a structure like

Emp
{
Emp_id ID ;
}

these id's would be passed to stored procedure through a method in java which returns the collection of ids.I am not sure how to write this stored prcedure...can someone please help me

Regards
Neha
 
Mike Zal
Ranch Hand
Posts: 144
Fedora Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I may be reading your requirements wrong, but it seems very strange. It sounds like you are trying to:
1) Create a stored procedure that accepts multiple IDs (in an unidentified structure)
2) Have the stored procedure create a table
3) Return some the same values specified in step 1
4) Be able to call the procedure from java

I am not sure what you are trying to do since it isn't very well defined. If you are asking for database help, you need to specify which kind of database you are using.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic