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

Home -> Community -> Usenet -> c.d.o.misc -> BIT_COMPLEMENT giving errors..

BIT_COMPLEMENT giving errors..

From: Shishir <shishir456_at_gmail.com>
Date: Wed, 04 Jul 2007 04:11:59 -0700
Message-ID: <1183547519.163409.145670@z28g2000prd.googlegroups.com>


hi friends,

I am trying to migrate a t-sql code to pl/sql code using oracle migration workbench..
i have modfied the code to include xml handling functions in pl/sql . On compiling i am getting the following errors. 'IsVisible' is a column in the LIBRARYTree and it is of type bit holiding only 0 0r 1..The errors are :

Line # = 18 Column # = 4 Error Text = PL/SQL: SQL Statement ignored Line # = 19 Column # = 31 Error Text = PLS-00306: wrong number or types of arguments in call to 'BIT_COMPLEMENT' Line # = 19 Column # = 23 Error Text = PL/SQL: ORA-00904: "UTL_RAW"."BIT_COMPLEMENT": invalid identifier

CREATE OR REPLACE PROCEDURE usp_LIBRARYHideUnhideTreeNodes (

)
AS
BEGIN     --add the passed xml string to the table with the xmltype column     INSERT INTO XMLTEST values
   (XMLTYPE(v_paramMyXml));

   UPDATE LIBRARYTree

      SET IsVisible = UTL_RAW.BIT_COMPLEMENT(IsVisible)
      WHERE NodeId IN ( select extractValue(data_xml,'HiddenNodes/Node/
id' )  as nodefinder
                        from XMLTEST);

 END; Any help in this regard will be appreciated??

Thanks in advance.

Shishir. Received on Wed Jul 04 2007 - 06:11:59 CDT

Original text of this message

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