PL/SQL: 整除 ,PLS-00357
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.03.15 19:13
分类: Oracle基础/数据仓库/BI
出处: http://moonsoft.itpub.net/post/15182/272203
---------------------------------------------------------------
PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context
1.
select trunc(21/5)
from dual;
怀念JAVA的 % 和 / ...
2. 使用
TYPE pick_batch_type IS RECORD (
-- PICK_BATCH_ID NUMBER ,
BATCH_NUMBER NUMBER ,
PICKED_DATE DATE,
BATCH_ID NUMBER,
SHIP_METHOD_ID NUMBER,
OE_HEADER_ID NUMBER,
OE_LINE_ID NUMBER,
DELIVER_NUMBER NUMBER,
INVENTORY_ITEM_ID NUMBER,
LOCATOR_IN_ID NUMBER,
LOCATOR_OUT_ID NUMBER,
PICKED_FLAG VARCHAR2(2),
ORG_ID NUMBER,
CREATION_DATE DATE ,
CREATED_BY NUMBER ,
LAST_UPDATED_BY NUMBER ,
LAST_UPDATE_DATE DATE
);
--po_rec_in po_import_rec_type;
TYPE pick_batch_array IS TABLE OF pick_batch_type
INDEX BY BINARY_INTEGER;
pick_batch_in pick_batch_array;
赋值:
pick_batch_in (v_capacity).pick_batch_id :=
oe_pick_batch_s.NEXTVAL;
出现:
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 valid examples follow: SELECT ename, emp.deptno, dname INTO my_ename, my_deptno, my_dept .FROM emp, dept WHERE emp.deptno = dept.deptno; DECLARE last_name emp.ename%TYPE; dept_rec dept%ROWTYPE;
Action: Remove or relocate the illegal reference.
