|
![](/images/resource/spacer.gif) |
|
การสร้าง PROCEDURE ด้วย SQL หรือ ORACLE>>TOAD ไม่รู้ว่าผิดตรงไหนขอความช่วยเหลือหน่อยค่ะ |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
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
![](/images/adv.jpg?v=1001)
|
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2011-07-05 16:12:51 |
By :
img |
View :
1871 |
Reply :
1 |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
LINE ที่เท่าไหร่ครับ ![](/images/bbcode/grin.gif?v=1001)
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2011-07-05 17:07:31 |
By :
webmaster |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 04
|