dungbibum
29-09-2004, 13:02
mình có viết cái này khi compile thì bị lổi:
*/
CREATE OR REPLACE Procedure A3 (
m_ident_in IN PRD00.PART_LIST.S_PIDENTNR%TYPE ,
m_ver_in IN PRD00.PART_LIST.C_PART_VERSION%TYPE,
m_option IN VARCHAR2 DEFAULT 'TEST'
)IS
BEGIN
DECLARE
-- main variables
coid_temp PRD00.PART_LIST."$COID"%TYPE;
max_id A_OUTPUT.out_ref%TYPE;
status PRD00.PART_LIST.C_MATURITY%TYPE;
c_O_user PRD00.PART_LIST.P_CO_USER%TYPE;
p_number CDM.MULTISITE_QUEUE.PART_NUMBER%TYPE;
-- Cursurs ------------------------------------------
CURSOR part_cur(
p_ident PRD00.PART_LIST.S_PIDENTNR%TYPE,
p_ver PRD00.PART_LIST.C_PART_VERSION%TYPE)
IS
SELECT * from PRD00.PART_LIST
WHERE S_PIDENTNR = p_ident
AND C_PART_VERSION = p_ver;
CURSOR multi_queue_cur(
p_number CDM.MULTISITE_QUEUE.PART_NUMBER%TYPE,
p_verion CDM.MULTISITE_QUEUE.PART_REVISION%TYPE)
IS
SELECT * from CDM.MULTISITE_QUEUE
WHERE PART_NUMBER = p_number
AND PART_REVISION = p_verion;
Error: 15/13 PLS-00201: identifier 'CDM.MULTISITE_QUEUE' must be declared
các bạn giúp mình nghe. caḿ ơn nhiều
*/
CREATE OR REPLACE Procedure A3 (
m_ident_in IN PRD00.PART_LIST.S_PIDENTNR%TYPE ,
m_ver_in IN PRD00.PART_LIST.C_PART_VERSION%TYPE,
m_option IN VARCHAR2 DEFAULT 'TEST'
)IS
BEGIN
DECLARE
-- main variables
coid_temp PRD00.PART_LIST."$COID"%TYPE;
max_id A_OUTPUT.out_ref%TYPE;
status PRD00.PART_LIST.C_MATURITY%TYPE;
c_O_user PRD00.PART_LIST.P_CO_USER%TYPE;
p_number CDM.MULTISITE_QUEUE.PART_NUMBER%TYPE;
-- Cursurs ------------------------------------------
CURSOR part_cur(
p_ident PRD00.PART_LIST.S_PIDENTNR%TYPE,
p_ver PRD00.PART_LIST.C_PART_VERSION%TYPE)
IS
SELECT * from PRD00.PART_LIST
WHERE S_PIDENTNR = p_ident
AND C_PART_VERSION = p_ver;
CURSOR multi_queue_cur(
p_number CDM.MULTISITE_QUEUE.PART_NUMBER%TYPE,
p_verion CDM.MULTISITE_QUEUE.PART_REVISION%TYPE)
IS
SELECT * from CDM.MULTISITE_QUEUE
WHERE PART_NUMBER = p_number
AND PART_REVISION = p_verion;
Error: 15/13 PLS-00201: identifier 'CDM.MULTISITE_QUEUE' must be declared
các bạn giúp mình nghe. caḿ ơn nhiều