-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: Rahul Vatsalya
Message 3 in Discussion

I am using aglobal temporary table in my oracle SP.  While returning data from 
this temp table to ref cursor (output parameter) , my code is giving error that 
Object no longer exists.  If I user physical table instead of global temporary 
table, oit workes fine. code is  
  
Insert into TEMP  // temp is physical table 
Select * from tempmenu; 
 
OPEN p_cur_Locations FOR 
SELECT * FROM tempmenu;  // This tempmenu is global temporary table. 
-- The above code is giving error in asp.net 
IF I Use 
OPEN p_cur_Locations FOR 
SELECT * FROM temp;   // using physical table instead of temporary table  
it workes fine. 
Please help 
regards 
Rahul

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member 
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you 
received this message by mistake, please click the "Remove" link below. On the 
pre-addressed e-mail message that opens, simply click "Send". Your e-mail 
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to