惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

U
Unit 42
T
Threatpost
C
CERT Recently Published Vulnerability Notes
Recent Commits to openclaw:main
Recent Commits to openclaw:main
Security Archives - TechRepublic
Security Archives - TechRepublic
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
K
Kaspersky official blog
Application and Cybersecurity Blog
Application and Cybersecurity Blog
Attack and Defense Labs
Attack and Defense Labs
N
News and Events Feed by Topic
Project Zero
Project Zero
H
Heimdal Security Blog
C
Cybersecurity and Infrastructure Security Agency CISA
Know Your Adversary
Know Your Adversary
Google Online Security Blog
Google Online Security Blog
W
WeLiveSecurity
D
Darknet – Hacking Tools, Hacker News & Cyber Security
Schneier on Security
Schneier on Security
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
N
News | PayPal Newsroom
Hacker News - Newest:
Hacker News - Newest: "LLM"
H
Hacker News: Front Page
L
LINUX DO - 热门话题
Spread Privacy
Spread Privacy
T
Threat Research - Cisco Blogs
Cloudbric
Cloudbric
V
Vulnerabilities – Threatpost
Hacker News: Ask HN
Hacker News: Ask HN
S
Securelist
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
TaoSecurity Blog
TaoSecurity Blog
NISL@THU
NISL@THU
N
News and Events Feed by Topic
S
Security Affairs
The Last Watchdog
The Last Watchdog
T
Tor Project blog
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
T
The Exploit Database - CXSecurity.com
Simon Willison's Weblog
Simon Willison's Weblog
P
Palo Alto Networks Blog
AWS News Blog
AWS News Blog
P
Proofpoint News Feed
C
Cisco Blogs
C
Cyber Attacks, Cyber Crime and Cyber Security
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
L
LINUX DO - 最新话题
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
T
Tenable Blog
C
CXSECURITY Database RSS Feed - CXSecurity.com
S
Schneier on Security

博客园 - Jeet

[转]TFS.VisualStudio.com TF30063: You are not authorized to access Collection 删除SQL数据库中所有的表 LoadLibrary返回值为0 解决64位平台上的"BadImageFormatException was unhandled" Post-Build event不能注册到全局缓存解决办法 Oracle相关博客转移 使用Outlook 2010,拖拽大于20M附件发生“附件大小超过了允许的范围”提示的解决方法 WIN7下丢失的光驱解决办法:由于其配置信息不完整或已损坏,Windows 无法启动这个硬件设备 Use OpenLDAP as security provider in Oracle UCM 11g 解决RedHat AS5 RPM安装包依赖问题 Using WSDLs in UCM 11g like you did in 10g 在64位Windows 7上安装Oracle UCM 10gR3 VS2008加Visio for Enterprise Architects安装方法 The Definitive Guide to Stellent Content Server Development ORACLE 10G EM错误解决 - Jeet PMP证书续期换证操作 玩儿条形码之条码打印 Vista下附加Sql Server数据库报5123的错误 - Jeet - 博客园 玩儿条形码之从DOS打印到USB打印机端口
使用ODP.NET连接Oracle数据库一个OracleCommand运行多条SQL语句的方法
Jeet · 2012-01-12 · via 博客园 - Jeet

长时间没有写用.Net访问Oracle的程序了,写起来才发现ODP.Net基本上是比较主流的选择。反正语法上也没什么差别,写语句,F5开始编译。

报“错误:ORA-00911: 无效字符”,把SQL语句拷到SqlDeveloper下运行正常,仔细查了一下,把Insert语句后的分号拿掉后正常运行;

因系统是连接实时的行情数据,不想太频繁的写入数据库,所以把语句放到Queue里,隔一段时间再Decueue统一运行,这样子一来一个OracleCommand会包含多个Insert的SQL语句,不加分号又不行。好,重新加上分号,又是“Invalid Character”,后来通过Decueue时使用“Begin" +SQL语句 +"end;"解决,实现一个OracleCommand包含多个SQL语句。