0 Replies Latest reply on Nov 6, 2013 3:01 PM by madahvidubasi-Oracle

    How to drop a temp table in bi publisher




      We are using Bi publisher 10g with sybase and we have a query which uses temporary table


      Below is the sample T-sql query

      Ex :


      Select column1,column2 into temp_table from table1

      Select column1 from temp_table

      drop temp_table


      We are not able to drop the temp_table in bi publisher. We tried using functions to place them in 'After Trigger' of bip but the sybase function does not allow 'Drop' command to be used in it.


      Also, Does 'exec' command work on bip?


      Can some one please suggest a solution