BIT_COMPLEMENT function giving errors..
Date: Wed, 04 Jul 2007 04:11:31 -0700
Message-ID: <1183547491.590362.180540_at_d30g2000prg.googlegroups.com>
[Quoted] 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 (
- Add the parameters for the stored procedure here v_paramMyXml IN CLOB DEFAULT NULL
)
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 - 13:11:31 CEST