Home » SQL & PL/SQL » SQL & PL/SQL » Getting Error : ORA-00911: invalid character (Oracle,9i)
Getting Error : ORA-00911: invalid character [message #318842] Thu, 08 May 2008 03:28 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
FUNCTION KAY (inq IN VARCHAR2) RETURN NUMBER
IS
nIDq NUMBER(25);
--
BEGIN
--
SELECT OPD_SURROGATE_SEQ.NEXTVAL@%%jack_DATABASE%% INTO nIDq FROM dual; -- Error Line
RETURN (nID);
--
EXCEPTION
WHEN INVALID_NUMBER THEN
RETURN NULL;

END;

Kindly suggest.
Re: Getting Error : ORA-00911: invalid character [message #318844 is a reply to message #318842] Thu, 08 May 2008 03:42 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is "%%jack_DATABASE%%"?

Regards
Michel
Previous Topic: How to multiply one column data to another column
Next Topic: Procedure not returning value due to a select statement
Goto Forum:
  


Current Time: Sat Dec 10 20:12:56 CST 2016

Total time taken to generate the page: 0.09967 seconds