b**********n
发帖数: 3 | 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 | s**********i
发帖数: 711 | 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:
| v**m
发帖数: 242 | 3 SELECT columnname INTO locator_var FROM tablename
【在 s**********i 的大作中提到】
:
: select into? what's that?
| b**********n
发帖数: 3 | 4 I found the error --- lack of ";" at the end of where clause.
~~~~~~~~~!!!! |
|
