PLS-00357:当立即执行块问题描述 投票:0回答:1thanks用于使用失败的代码和错误消息更新问题。 EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || &&PowerTsmUsername..&&SeqName || ' RESTART START WITH ' || dummy; 您应该能够简单地删除单个引号:sql oracle-database plsql oracle-sqldeveloper sqlplus ...
PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context Cause: A reference to database table, view, or sequence was found in an inappropriate context. Such references can appear only in SQL statements or (excluding sequences) in %TYPE and %ROWTYPE declarations. Some...
:NEW.ID:=SEQ_TRADE_RECODE.NEXTVAL; END; 报错: PL/SQL: Statement ignored PLS-00357: Table,View Or Sequence reference 'SEQ_TRADE_RECODE.NEXTVAL' not allowed in this context 我明明记得以前这样做没问题啊,我打开以前的数据库一模一样啊。后来想了想,唯一的区别是我一个连的10g的一个是11g,上网一查...