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,
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