Home » SQL & PL/SQL » SQL & PL/SQL » getting compilation errors (oracle 10g)
getting compilation errors [message #381828] Tue, 20 January 2009 01:03 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
i am compiling a stored procedure and iam getting following errors in sql*plus.how to overcome this.

CREATE OR REPLACE PROCEDURE VW_SearchInfo(x out varchar2)
is
PTemp        		INT;
    POLDid       		NUMBER(10,0);
    PHitListid   		NUMBER(10,0);
    PNodeid	     		NUMBER(10,0);
    PSearchName  		VARCHAR2(255);
    Token		        VARCHAR2(255);
    PFieldText			VARCHAR2(255);
    PContaintsText		VARCHAR2(255);
    PName			VARCHAR2(255);
    PRetval                     VARCHAR2(255);
 BEGIN
        
	BEGIN
            Select VWUpdateSearch('0		1	3	africa		0	0					vwadmin	10.4.8.25	1')
	    into PRetval from dual;
	    EXCEPTION
		   WHEN NO_DATA_FOUND THEN
			PRetval:=0;
			NULL;
		   WHEN OTHERS THEN
			PRetval:=0;
			NULL;
        END;
        
	IF(PRETVAL>0) THEN
	  BEGIN
	     VWRemoveSearchAuthors(PRetval);
	     VWRemoveSearchDocTypes(PRetval);
	     VWRemoveSearchConds(PRetval);
	  END; 
        END IF;


         BEGIN
	     Select VWSearch('321	0	1001	vwadmin	10.4.8.25	0	1	Search Criteria =  [Index contains = africa] [Location = LOCAL.room_2009\New Cabinet\New Drawer\Test Scenarios] [ Node Id = 3] [search in comment = false] [previous version = false] ')
	     into PFieldText from dual;
             EXCEPTION
		   WHEN NO_DATA_FOUND THEN
			PFieldText:=0;
			NULL;
		   WHEN OTHERS THEN
			PFieldText:=0;
			NULL;
        END;
 END;



following one are errors

15/13 PL/SQL: SQL Statement ignored
15/20 PL/SQL: ORA-00904: "VWUPDATESEARCH": invalid identifier
15/20 PLS-00306: wrong number or types of arguments in call t
'VWUPDATESEARCH'

33/7 PL/SQL: SQL Statement ignored
33/14 PL/SQL: ORA-00904: : invalid identifier

[EDITED by LF: applied [code] tags]

[Updated on: Tue, 20 January 2009 01:33] by Moderator

Report message to a moderator

Re: getting compilation errors [message #381842 is a reply to message #381828] Tue, 20 January 2009 01:35 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It appears that you'll have to use a valid identifier, and provide correct number or type of arguments to a procedure/function you use.
Re: getting compilation errors [message #381852 is a reply to message #381828] Tue, 20 January 2009 02:24 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
pretval is defined as varchar2.
Use it that way. You cannot compare a string like this:
if pretval > 0
Previous Topic: How do you avoid this sql warning?
Next Topic: PL/SQL loops
Goto Forum:
  


Current Time: Thu Dec 12 23:47:28 CST 2024