|
|
|
การสร้าง PROCEDURE ด้วย SQL หรือ ORACLE>>TOAD ไม่รู้ว่าผิดตรงไหนขอความช่วยเหลือหน่อยค่ะ |
|
|
|
|
|
|
|
Code (C#)
CREATE OR REPLACE PROCEDURE UP_PFSR0026
(
UP_STUDENT_ID student_maintenance.STUDENT_ID%type,
UP_PROFESSOR_STATUS student_maintenance.PROFESSOR_STATUS%type,
UP_PERIOD_ID student_maintenance.PERIOD_ID%type,
UP_COMM stu_student_status.COMM%type,
UP_TEL stu_student_status.TEL%type,
UP_SIR_NAME_CODE SIR_NAME_CONFIG.SIR_NAME_CODE%type,
UP_FIRST_NAME_THAI STUDENT.FIRST_NAME_THAI%type,
UP_LAST_NAME_THAI STUDENT.LAST_NAME_THAI%type,
up_createdate stu_student_status.createdate%type,
up_createby stu_student_status.createby%type
)
AS
BEGIN
INSERT INTO student_maintenance(STUDENT_ID,PROFESSOR_STATUS,PERIOD_ID)
VALUES (UP_PFSR0026.UP_STUDENT_ID,UP_PFSR0026.UP_PROFESSOR_STATUS,UP_PFSR0026.UP_PERIOD_ID,UP_PFSR0026.UP_COMM,
UP_PFSR0026.UP_TEL,UP_PFSR0026.UP_SIR_NAME_CODE,UP_PFSR0026.UP_FIRST_NAME_THAI,
UP_PFSR0026.UP_LAST_NAME_THAI,current_date,up_createby);
END;
ผิดตรงไหนอ่ะ มันบอกว่า
Warning: PROCEDURE created with compilation errors.
Tag : ASP, MySQL, Oracle
|
|
|
|
|
|
Date :
2011-07-05 16:12:51 |
By :
img |
View :
1859 |
Reply :
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LINE ที่เท่าไหร่ครับ
|
|
|
|
|
Date :
2011-07-05 17:07:31 |
By :
webmaster |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|