SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter command in procedure

565652Mar 8 2007 — edited Mar 8 2007

Hi,

I am stuck in a simple plsql procedure.
I have two table
1. course(cno, cname) cno is PK
2. student(sno, sname, cno) cno is FK of course

I have to write a procedure so that if I change a course number by some new value in the course table, that change is also reflected in student table.

I tried writing a procedure and disabling the constraint in the student table, but it won’t accept the alter command in the procedure.
The problem is that I have to write a procedure for this. I can’t use the sql query directly.
Any help would be highly appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2007

Added on Mar 8 2007

6 comments

446 views