Redian新闻
>
[转载] what's wrong with this PL/SQL
avatar
[转载] what's wrong with this PL/SQL# Database - 数据库
b*n
1
【 以下文字转载自 Programming 讨论区,原文如下 】
发信人: blackjackwon (BlackJack), 信区: Programming
标 题: what's wrong with this PL/SQL
发信站: The unknown SPACE (Thu Sep 19 16:15:05 2002) WWW-POST
I wrote a simple PL/SQL to reading CLOB. However, I got an error saying:
"
select SEQUENCE into locator_var
*
ERROR at line 9:
ORA-06550: line 11, column 22:
PL/SQL: ORA-00933: SQL command not properly ended
ORA-06550: line 9, column 1:
PL/SQL: SQL Statement ignored
"
My PL/SQL looks like this:
decla
avatar
s*i
2

select into? what's that?

【在 b**********n 的大作中提到】
: 【 以下文字转载自 Programming 讨论区,原文如下 】
: 发信人: blackjackwon (BlackJack), 信区: Programming
: 标 题: what's wrong with this PL/SQL
: 发信站: The unknown SPACE (Thu Sep 19 16:15:05 2002) WWW-POST
: I wrote a simple PL/SQL to reading CLOB. However, I got an error saying:
: "
: select SEQUENCE into locator_var
: *
: ERROR at line 9:
: ORA-06550: line 11, column 22:

avatar
v*m
3
SELECT columnname INTO locator_var FROM tablename

【在 s**********i 的大作中提到】
:
: select into? what's that?

avatar
b*n
4
I found the error --- lack of ";" at the end of where clause.
~~~~~~~~~!!!!
相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。