Oracle query

[sandhya14]

Hi all, How to insert values to a temptable by executing a storedprocedure... Ex :- INSERT INTO TempYearEndBal exec BLYearEndLeaveTcktBalRep; Getting error while trying to insert the values to "TempYearEndBal" by executing the SP "BLYearEndLeaveTcktBalRep"... can anybody help me to come out from this issue... Thanks in Advance...

[Mycroft Holmes]

Not sure about Oracle but you cannot do this in SQL Server (and I would be surprised if Oracle supports this). In SQL Server I would change your temptable to a global temp table and do the insert in the BLYearEndLeaveTcktBalRep proc.

[sandhya14]

U can do this in SQL server.... Inside the SP itself create the temp table and try to insert like : INSERT INTO #TempYearEndBal exec BLYearEndLeaveTcktBalRep this will work.... But in Oracle,what is the equlent way to do this?...