2021腾讯云限时秒杀，爆款1核2G云服务器298元/3年！（领取2860元代金券），
地址：https://cloud.tencent.com/act/cps/redirect?redirect=1062

2021阿里云最低价产品入口+领取代金券(老用户3折起)，
入口地址：https://www.aliyun.com/minisite/goods

推荐：[置顶] 分布式内存网格Hazelcast源码导读

去年项目需要看了hazelcast源码，当时记录的笔记。 Node是节点的抽象，里面包含节点引擎、客户端引擎、分区服务、集群服务、组播服务、连接管理、命令管理、组播

up vote 0 down vote favorite

I have a website connected to an Oracle database. When I execute the following SQL I get a result returned:

select distinct name from CONTACTS
            where upper(EMAIL) like upper(:info) 
            AND HASACCESS（NAME, :userid) = 'Y' 
            order by NAME desc

I have migrated the same code to a new server. When this code runs I now get the error:

ORA-00911: invalid character\n

I do not have a ; on the end which most people get when they get this error.

Doing some trial and error it is crapping on the call to the Stored Producer / Function call. The database that both bits of code are referencing are the same.

It is not to do with the bind variables because if I hard code them then I still get the error.

I am really perplexed on this one.

c# asp.net oracle iis ora-00911 share | improve this question edited Oct 21 '15 at 1:22 asked Oct 20 '15 at 9:33 Liam 150 7      Please show us your effective C# code containing and executing the SQL command. –  Codo Oct 20 '15 at 12:12 add a comment  | 

1 Answer 1

active oldest votes up vote 1 down vote

I have found the issue. It can be seen here

select distinct name from CONTACTS
            where upper(EMAIL) like upper(:info) 
            AND HASACCESS（NAME, :userid) = 'Y' 
            order by NAME desc

When the function is being called it is using the wrong bracket. It is using （ it should be (.

PLSQL can run either bracket fine.

Changing the bracket the code now works.

Must be a difference in Oracle driver support. Or something else environmental. Hopefully this may help someone else one day...

share | improve this answer edited Oct 21 '15 at 8:52 answered Oct 21 '15 at 1:20 Liam 150 7 add a comment  | 

Your Answer

  draft saved draft discarded

Sign up or log in

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Post as a guest

Name Email discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged c# asp.net oracle iis ora-00911 or ask your own question.

推荐：详解应对平台高并发的分布式调度框架TBSchedule

               tbschedule是一款非常优秀的高性能分布式调度框架，非常高兴能分享给大家。这篇文章是我结合多年tbschedule使用经验和研读三遍源码的基础上完成