2 Replies Latest reply: Jun 22, 2011 1:59 AM by 867407 RSS

    Code error during prosedure migration to Oracle from SqlServer2005

    867407
      spUTLGetSQLTblSource(v_NodeType,
      v_tblHierarchy,
      v_tblDesc,
      v_DataLevel,
      v_FrmID,
      v_Lvl,
      v_HierarchyId);
      DBMS_OUTPUT.PUT_LINE('@HierID=' || CAST(v_HierID AS VARCHAR2(100)));
      DBMS_OUTPUT.PUT_LINE('@NodeType=' || CAST(v_NodeType AS VARCHAR2(100)));
      DBMS_OUTPUT.PUT_LINE('@NodeTypeReqd=' || CAST(v_NodeTypeReqd AS VARCHAR2(100)));
      v_SQLstr := 'INSERT INTO #tmpDet (PHierId, PNodeId, PNodeType) SELECT PHierID, PNodeId, PNodeType FROM ' || v_tblHierarchy || ' WHERE ActiveStatus=1 AND HIerID=' || CAST(v_HierID AS VARCHAR2) ;
      DBMS_OUTPUT.PUT_LINE(v_SQLstr);
      EXECUTE IMMEDIATE v_SQLstr;



      Error(36,64): PLS-00103: Encountered the symbol "(" when expecting one of the following: . ) @ % The symbol ")" was substituted for "(" to continue.