-
Procedure not working
Hey guys,
I was trying to do a procedure so if the rate is greater than 20000 certain values will be inserted in a table but the following code doesn't work and I was just wondering where I went wrong?
Thanks in advance.
CREATE OR REPLACE PROCEDURE sch_1 IS
BEGIN
IF T.RATE > 20000
INSERT INTO SCH
(SCHID, NAME)
vALUES(98, JO);
END SCH_1;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|