Oracle Query
-
create or replace PROCEDURE PEAP_SelectEmpAppraiser ( AppraiserID IN VARCHAR2 DEFAULT NULL, Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE PEAP_SelectEmployeesByApr'; Hi all.... I dont know where to post this issue..so am putting it here ... this is my oracle statement...while executing its giving an error: 21/29 PL/SQL: ORA-00923: FROM keyword not found where expected please help me to solve this issue..:-( its urgent... INSERT INTO PEAP_SelectEmployeesByApr SELECT emp_code AS EmployeeID, emp_code || ' ' || l_name || ' ' || f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = PEAP_SelectEmpAppraiser.AppraiserID); Insert into PEAP_SelectEmployeesByApr SELECT emp_code as EmployeeID ,emp_code || ' ' || l_Name || ' ' || f_Name AS SurNameFirstName FROM emp_master WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and isnull ( Appraiser , '') = '' and emp_code not in ( select EmployeeID from PEAP_SelectEmployeesByApr); OPEN Cur_RCT1 FOR SELECT DISTINCT EmployeeID, SurNameFirstName FROM PEAP_SelectEmployeesByApr; END; /
-
create or replace PROCEDURE PEAP_SelectEmpAppraiser ( AppraiserID IN VARCHAR2 DEFAULT NULL, Cur_RCT1 OUT GLOBALPKG.RCT1 ) AS BEGIN EXECUTE IMMEDIATE 'TRUNCATE TABLE PEAP_SelectEmployeesByApr'; Hi all.... I dont know where to post this issue..so am putting it here ... this is my oracle statement...while executing its giving an error: 21/29 PL/SQL: ORA-00923: FROM keyword not found where expected please help me to solve this issue..:-( its urgent... INSERT INTO PEAP_SelectEmployeesByApr SELECT emp_code AS EmployeeID, emp_code || ' ' || l_name || ' ' || f_name AS SurNameFirstName FROM emp_master WHERE (Appraiser = PEAP_SelectEmpAppraiser.AppraiserID); Insert into PEAP_SelectEmployeesByApr SELECT emp_code as EmployeeID ,emp_code || ' ' || l_Name || ' ' || f_Name AS SurNameFirstName FROM emp_master WHERE ( Reporting_To = PEAP_SelectEmpAppraiser.AppraiserID) and isnull ( Appraiser , '') = '' and emp_code not in ( select EmployeeID from PEAP_SelectEmployeesByApr); OPEN Cur_RCT1 FOR SELECT DISTINCT EmployeeID, SurNameFirstName FROM PEAP_SelectEmployeesByApr; END; /
You're looking for the "General Database[^]" forum...
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008