Home » SQL & PL/SQL » SQL & PL/SQL » getting compilation errors with procedure (oracle 10g)
getting compilation errors with procedure [message #384237] Tue, 03 February 2009 00:18 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: getting compilation errors with procedure [message #384309 is a reply to message #384237] Tue, 03 February 2009 03:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Care to share what the error is, and at what line it occurrs?
Re: getting compilation errors with procedure [message #384314 is a reply to message #384237] Tue, 03 February 2009 04:13 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
I was feeling smug at being quoted until I noticed all the typos....
Embarassed
Previous Topic: To avoid insertions using merge in oracle 9.2.0.8.0 release. (merged)
Next Topic: Urgent help in Extracting numbers only
Goto Forum:
  


Current Time: Thu Dec 08 20:36:53 CST 2016

Total time taken to generate the page: 0.10834 seconds