Maaf rekan-2.... saya lupa SMPL_NAME belum di-declare.
Skr udah OK.
Lagi belajar SP & Trigger nih, jadi belum familiar.
Salam,
People learn from mistakes.
----- Original Message -----
From: Ariefn
To: [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 6:15 AM
Subject: [Delphindo] APANYA YG SALAH ?
Di IB saya buat SP sbb :
CREATE PROCEDURE P_CREATE_TMPLT (TMPLT_NAME Varchar(30), SMPL_DT Date,
SMPL_TM Char(5))
AS
declare variable PRDCT_NAME Varchar(30);
declare variable SMPL_PNT_NAME Varchar(30);
declare variable PRDCT_SPEC_NAME Varchar(40);
begin
SELECT SMPL_PNT_NAME, PRDCT_SPEC_NAME FROM TEMPLATE
WHERE TMPLT_NAME = :TMPLT_NAME
INTO :SMPL_PNT_NAME, :PRDCT_SPEC_NAME;
SELECT PRDCT_NAME FROM SMPL_PNT
WHERE SMPL_PNT_NAME = :SMPL_PNT_NAME
INTO :PRDCT_NAME;
/*====== SAMPAI DISINI BAGUS ============ */
EXECUTE PROCEDURE P_GET_SMPL_NAME :SMPL_PNT_NAME, :SMPL_DT
RETURNING_VALUES :SMPL_NAME;
INSERT INTO SAMPLE
(SMPL_NAME,TMPLT_NAME,SMPL_PNT_NAME,SMPL_DT,SMPL_TM,PRDCT_NAME,PRDCT_SPEC_NAME)
VALUES(:SMPL_NAME,:TMPLT_NAME,:SMPL_PNT_NAME,:SMPL_DT,:SMPL_TM,:PRDCT_NAME,:PRDCT_SPEC_NAME);
end ^
Pada statement diatas, error yg muncul adalah
" Error -206 unknown column "
(tanpa disebutkan column mana yg salah)
Kemungkingkinan 2 statement terakhir yg menyebabkan salah.
Tapi saya sudah perhatikan betul-2 TIDAK ADA column yg "ASING" pada statement tsb di
database.
(Kalau 2 statement tsb saya hilangkan, maka SQL tsb berjalan lancar)
Kira-2 salahnya dimana ya.. ?
TIA
Salam.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/xaxhjB/hdqFAA/xGHJAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
