cast error ...

From: Shishir <shishir456_at_gmail.com>
Date: Fri, 06 Jul 2007 00:55:02 -0700
Message-ID: <1183708502.475491.294400_at_g37g2000prf.googlegroups.com>

hi ,
[Quoted] hey this is the sql procedure which im dealing wit . On compiling im getting the following errors :
Line # = 13 Column # = 46 Error Text = PL/SQL: ORA-00906: missing left parenthesis

CREATE OR REPLACE PROCEDURE usp_ESTMATEGetAttributes (
  cv_1 IN OUT SYS_REFCURSOR
)
AS
BEGIN
   OPEN cv_1 FOR

      SELECT AttributeName,
             AttributeType,
             AttributeId,
        ----this line is the problem--
             CAST(AttributeID AS VARCHAR2) || ',' || AttributeType
AttributeIDType,
             CatalogName
        FROM ESTMATEMasterAttributes ;

END; To me it seems correct . Can someone point out wats the mistake??

Thanks in advance,
Shishir. Received on Fri Jul 06 2007 - 09:55:02 CEST