getting compilation errors with procedure [message #384237] |
Tue, 03 February 2009 00:18  |
rajasekhar857
Messages: 500 Registered: December 2008
|
Senior Member |
|
|
iam getting compilation errors with below procedure.
CREATE OR REPLACE PROCEDURE VWCopyNodeRules(ClientIP Varchar2, UserName Varchar2,Nodeid int,NewParent int) AS
DocTypeid INT;
Indexid INT;
Parentids Varchar(2000);
IndexValue VARCHAR(255);
BEGIN
Parentids := VWGetNodeParentIDs(Nodeid,0);
Parentids := TO_CHAR(Nodeid ) || Parentids;
OPEN NodeRule_CUR FOR ('SELECT DocTypeid, Indexid, IndexValue From NodeIndexRules Where Nodeid IN (' || Parentids ||')');
LOOP
FETCH NodeRule_CUR INTO DocTypeid, Indexid,IndexValue;
EXIT WHEN NodeRule_CUR%NOTFOUND;
BEGIN
INSERT INTO NodeIndexRules(Nodeid,DocTypeid,Indexid,IndexValue,CreatorName)
VALUES(NewParent,DocTypeid,Indexid,IndexValue,UserName);
FETCH NodeRule_CUR INTO DocTypeid, Indexid, IndexValue;
END LOOP;
END;
CLOSE NodeRule_CUR;
NULL;
END;
/ [EDITED by LF: applied [code] tags]
[Updated on: Tue, 03 February 2009 06:05] by Moderator Report message to a moderator
|
|
|
Re: getting compilation errors with procedure [message #384244 is a reply to message #384237] |
Tue, 03 February 2009 00:29   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
The solution is: you're getting compilation errors.
From one of your previous post:
cookiemonster wrote on Wed, 21 January 2009 14:04 | OK Let's back up a few steps here.
We don't know what you're trying to accomplish, we don't know your table structures or the relationships between them.
[...]
We don't you explain to use in words what it is you're trying achieve and we might be able to help you.
While you're at it please read http://www.orafaq.com/forum/t/88153/0/, especially the how to format your post section and use code tags in future.
|
Regards
Michel
[Updated on: Tue, 03 February 2009 00:30] Report message to a moderator
|
|
|
|
|