Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BIT_COMPLEMENT giving errors..

0 views
Skip to first unread message

Shishir

unread,
Jul 4, 2007, 7:11:59 AM7/4/07
to
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.

0 new messages