Execute Immediate : Can't run ...Please help

From: Pial <zislam_at_gmail.com>
Date: 22 Apr 2005 08:06:21 -0700
Message-ID: <795114e5.0504220706.78746ebb_at_posting.google.com>



Hi,

[Quoted] [Quoted] Can anybody tell me what's the wrong with the EXECUTE IMMEDIATE. I am just pasting the code. The problem is in the EXECUTE IMMEDIATE strSql;

Thanks in Advance
Zahir

---

AS 
PROCEDURE GET_LOOKUP (  	  pILOOKUP_LANGUAGECODE	   	  IN NUMBER,
                  pSLOOKUP_GROUP   IN VARCHAR2,   
   							  IO_CURSOR    IN OUT T_CURSOR)
   IS
        V_CURSOR T_CURSOR;
         strSql   VARCHAR2(1000);
    BEGIN
        
        strSql := 'SELECT DISTINCT LOOKUP.SLOOKUP_VALUE,
                    LOOKUP.SLOOKUP_LABEL FROM SFIS.LOOKUP';
        
        strSql := strSql || ' WHERE SLOOKUP_GROUP = ' ||
pSLOOKUP_GROUP;
        strSql := strSql || ' AND ILOOKUP_LANGUAGECODE = ' ||
pILOOKUP_LANGUAGECODE;
        
        
        IF (pSLOOKUP_GROUP='FacStatusEntryType') OR
(pSLOOKUP_GROUP='FacOwner') THEN
        
        OPEN V_CURSOR FOR
             strSql := strSql || ' ORDER BY LOOKUP.SLOOKUP_VALUE';
             
             EXECUTE IMMEDIATE strSql; 

             IO_CURSOR := V_CURSOR;
        ELSE
             OPEN V_CURSOR FOR
             
             strSql := strSql;
             
             EXECUTE IMMEDIATE strSql; 

             IO_CURSOR := V_CURSOR;
        
        END IF; 
        
  END GET_LOOKUP_VALUE_LABEL;

END PAC_LOOKUP;
Received on Fri Apr 22 2005 - 17:06:21 CEST

Original text of this message