ITKeyword,专注技术干货聚合推荐

注册 | 登录

Hazelcast: Java分布式内存网格框架(平台)

iihero 分享于

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使用经验和研读三遍源码的基础上完成

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

相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。