Home » SQL & PL/SQL » SQL & PL/SQL » Invalid character error
Invalid character error [message #261771] Thu, 23 August 2007 09:56 Go to next message
Messages: 8
Registered: July 2007
Junior Member
I tried to create a view which will get data from database link:
Select * from Table@linkname.xx.xx
Then I am getting the ORA:00911 error invalid character.

I am gettign the result if I try like this: Select *from Table@linkname.xx.xx; in SQLPLUS.
Now I need to create a view with the above select statement.
Create View V1
select * from Table@linkname.xx.xx;

Now I am getting the ORA:00911 error invalid character.

whether I need to put double quotes around dot in link name to avoid that error.
Can any one help me on this.
Thanks in advance

Re: Invalid character error [message #261792 is a reply to message #261771] Thu, 23 August 2007 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64729
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste what you really did.
And dont't forget:
Read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Always post your Oracle version (4 decimals).


Re: Invalid character error [message #261947 is a reply to message #261771] Fri, 24 August 2007 02:34 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You don't need and END; on a CREATE VIEW statement.
If that doesn't fix the problem, then (as Michel asks) show us what you've actually done.
Previous Topic: Please help me............(do you like my stupid unhelpful title?)
Next Topic: Number of days in current month
Goto Forum:

Current Time: Thu Apr 27 23:27:55 CDT 2017

Total time taken to generate the page: 0.13047 seconds