Search results for query: *

thanks a lot for looking into this!! Will check and get back to you.

Hi Dagon, Still dont understand how this is related in resolving my issues? I am not creating temp tables now , using below technique to for multiple dymanic tables. I used below technique to achive my target results. PROCEDURE trade_report(v_cur OUT sys_refcursor, date_from IN...

ok - in plain simple english - my requirement is to return a reference of cursor in procedures - I had series of inline sql (7-15 dependent on each other sqls to produce reports) . In these sqls I am creating temp tables and oputut of temp tables is used as input to other tables. I was getting...

Hi LKBrwnDBA, Thnaks for reply - not creating temp table dosent solve my purpose. I need to create temporary tables with different data at different time in order to get my output. In below example - trying to creat 4 different temp tables , but not sure how oracle works - can get test...

Hi LKBrwnDBA , Sorry I dind get you? Regarsd,

Hi taupirho , Thanks for your reply - actually I have got around 10-15 temporary tables needs to be created - not one. I first started with below - but not sure my I am getting error. So though of creating temp tables. Have been getting in below error if I bulk execute my procedure. Not been...

Hi Guys, I have been struggling to with creating temp table within a procedure and returning a cursor ref. Basically, I am trying to convert my in-line sql into procedures which returns cursor ref. Using inline SQL, I had created series of temporary tables - output of temp tables used as...

Hi Guys, I have been struggling to make my MS-Access to Oracle connectivity program work on one of the users PC. Below code works fine on my PC, but due to Oracle Client version conflict keep getting "The Oracle(tm) client and networking components were not found error" on users pc. Tried...

Hi Guys, I have been struggling to make my MS-Access to Oracle connectivity program work on one of the users pc. Below code works fine on my PC, but due to Oracle Client version conflict keep getting "The Oracle(tm) client and networking components were not found error" on users pc. Tried...