Refcursor runs in older version of toad but not in 11.5.1.2

I have a cursor that runs in the old Toad but not in the new version.
Is there a configuration that I need to set to successfully run this?

CREATE OR REPLACE PROCEDURE GET_SEQ_IDS_REF(P_I_SEQ_NAME IN VARCHAR2,

                  P_I_NUM_SEQ_TO_GET IN NUMBER,
                  P_O_SEQUENCE_RC OUT SYS_REFCURSOR) IS                  

/*****************************************************************************************
 NAME:      GET_SEQ_IDS
 PURPOSE:  This procedure retrieves a set of sequence ids for the passed in sequence.
==========
Ver        Date          Author             Description
----      ----------    -----------        ------------------------------------
*****************************************************************************************/
--VARIABLE DECLARATION. -----------
-----------------------------------
   P_SEQ_NAME       VARCHAR2(100) := P_I_SEQ_NAME;
   P_TTL_NUM        NUMBER := P_I_NUM_SEQ_TO_GET;
   V_SQL            VARCHAR2(1500);
   V_RETURN         VARCHAR2(1500);
   V_CONCAT_STRING  VARCHAR2(2000);
   V_NUM            NUMBER := 1;
   V_COUNTER        NUMBER := 1;
--=======================
--= Start main process  =
--=======================
BEGIN
     --===================================
     --= Gather Sequences into a string. =
     --===================================  

       WHILE V_NUM <> (P_TTL_NUM + 1) LOOP

         V_SQL := 'SELECT '||P_SEQ_NAME||'.NEXTVAL FROM DUAL';

         EXECUTE IMMEDIATE V_SQL INTO V_RETURN;

         commit;  

         IF V_NUM <> P_TTL_NUM THEN
            V_CONCAT_STRING := V_CONCAT_STRING ||V_RETURN||',';
         ELSE
            V_CONCAT_STRING := V_CONCAT_STRING ||V_RETURN;
         END IF;        

         V_NUM := V_NUM + 1;        

       END LOOP;  

      OPEN P_O_SEQUENCE_RC FOR SELECT V_CONCAT_STRING AS V_CONCAT_STRING FROM DUAL;
EXCEPTION

   WHEN OTHERS THEN

   sp_write_debug_message('55','GET_SEQ_IDS '||P_I_NUM_SEQ_TO_GET||' for '||p_i_seq_name,'ERR:'||SQLCODE||'-'||SUBSTR(SQLERRM,1,300));

END GET_SEQ_IDS_REF;
wpeterbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
No known reason for it to stop working.  While you wait for a better answer here, please run the code directly in SQL, rather than TOAD.  If it succeeds, then you will have proven nothing changed in the code.  And if it fails, the SQL*Plus will point you to the exact line that's failing.

Consider also asking in the forums at toadworld.com.

dvz
0
wpeterbAuthor Commented:
There is a difference between my computers.  The one it works on is 32bit and the new one that it doesn't work on is 64 bit.

It runs in both toad and sqlplus in my old system.
I only runs on sqlplus in my new system.
0
DavidSenior Oracle Database AdministratorCommented:
My next step, then, would be to check with quest tech support for known bugs on that release and platform.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wpeterbAuthor Commented:
Pursuing Support in Toad.  Best answer as to where the issue can be resolved Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.