Error: PLS-00103: Encountered the symbol "CREATE"
If you create package and encountered above error, please add / as below show.
CREATE OR REPLACE PACKAGE TEMPLATE1 IS
TYPE ARR_SEQ IS VARRAY(100) OF VARCHAR2(200);
FUNCTION FUN_CREATE_PROJECT_ID(IN_N IN NUMBER) RETURN ARR_SEQ;
END TEMPLATE1;
/
CREATE OR REPLACE PACKAGE BODY TEMPLATE1 IS
FUNCTION FUN_CREATE_PROJECT_ID(IN_N IN NUMBER) RETURN ARR_SEQ AS
N NUMBER;
I NUMBER;
V_VAL VARCHAR2(200);
V_ARR_SEQ ARR_SEQ;
BEGIN
N := NVL(IN_N, 0);
I := 1;
V_ARR_SEQ := ARR_SEQ();
LOOP
EXIT WHEN N <= 0;
SELECT SEQ_AUTO_ID.nextval INTO V_VAL FROM DUAL;
V_ARR_SEQ.EXTEND;
V_ARR_SEQ(I) := V_VAL;
N := N - 1;
I := I + 1;
END LOOP;
RETURN(V_ARR_SEQ);
END FUN_CREATE_PROJECT_ID;
END TEMPLATE1;
分享到:
相关推荐
解决方法 docker-ce安装时出现错误: dpkg: error processing package docker-ce (--configure): ...Errors were encountered while processing: docker-ce E: Sub-process /usr/bin/dpkg returned
Keil v5 Error: Encountered an improper argument 个人实测解决办法 实测运行正常咯,再也不出现仿真关不了debug情况了
CKPT: terminating instance due to error 472 Instance terminated by CKPT, pid = 11604 Wed Jun 8 21:04:47 2005 Starting ORACLE instance (normal) 解决办法: Oracle工程师建议安装Oracle补丁p3949307_9206_...
xml解析器失败时候可以尝试打开开始-运行-cmd 输入命令来进行解决
Download the attached file and extract it to the folder C:\Keil_v5\UV4. If you have installed PK51 to a different folder, you need to adapt the path accordingly. The file UV4.exe is replaced with ...
Keil-MDK Error Encountered an improper argument 问题解决办法实测有效,此问题属于keil的软件bug,在mdk5.2x版本中普遍出现,最新的mdk5.26版本也没有解决此软件bug,所以分享此解决办法让更多人免于受此问题困扰...
点击劫持:X-Frame-Options头缺失 in a frame because it set 'X-Frame-Options' to 'deny'
解决在Keil仿真时,退出仿真出现Encountered an improper argument错误。解决办法,将附件添加到kei的安装目录中即可C:\Keil_v5\UV4。将原来的替换即可
Driver_hook Driver_hook Driver_hook Driver_hook
dpkg: error processing package mysql-community-client (--install): dependency problems - leaving unconfigured Processing triggers for man-db (2.6.7.1-1ubuntu1) ... Errors were encountered while ...
[ERROR] Failed to execute goal org.wildfly.swarm:wildfly-swarm-plugin:2017.4.0:package (default) on project game: Execution default of goal org.wildfly.swarm:wildfly-swarm-plugin:2017.11.0:package ...
control method attempts to create 2 objects of the same name. This once again returns AE_ALREADY_EXISTS. When this exception occurs, it invokes the mechanism that will dynamically serialize the ...
This program has encountered an error (Use the arrows keys to scroll) Error see log for more info PartedUtil failed with message error can’t have a partition outside the disk Unable to read ...
Presents solutions for problems encountered in autonomous navigation. Explores the mathematical preliminaries needed to understand the proposed methodologies. Integrates computing, communications, ...
Socket编程中的Error捕获的中文解释,包括错误代码和中文释义
The handbook also presents challenges encountered in wireless sensor networks and offers ways to solve these problems. It addresses key matters associated with real-time data services and reviews the...
HoBIDS Sensors by Eli Glanz deg28@cs.columbia.edu ---- This package contains: Makefile GNU makefile for this ...4) If no errors were encountered while compiling, install everything: make install
When you encounter an unexpected error, the system now generates an error code which you should reference when filing Service Requests with Oracle Support. Unifier Mobile Application (Android) - ...
veteran author Wei-Meng Lee presents you with 100 unique recipes that you can apply today in order to discover solutions to some of the most commonly encountered problems that exist in Android ...