Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Execute Immediate : Can't run ...Please help

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

From: Pial <zislam_at_gmail.com>
Date: 22 Apr 2005 08:07:12 -0700
Message-ID: <795114e5.0504220707.5fbe197b@posting.google.com>


Hi,

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 - 10:07:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US