|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
||||
|
||||
|
problem with stored procedure
Hi,
I get errors when i try to compile this stored procedure: Code:
create or replace procedure addMovieTask(
a_movieID as number,
a_movieTaskDesc clob,
a_movieTaskStatus varchar2,
a_started date,
a_finished date,
a_due date
)
IS
v_movieTaskID number;
BEGIN
select sysdate from dual;
--get amt of movies in table
select count(*)
into v_movieTaskID
from movietasks;
--increment to get a unique ID
V_movieTaskID := V_movieTaskID + 1;
--insert new movie
insert into movietasks
values(v_movieTaskID,a_movieID,
a_movieTaskDesc,
a_movieTaskStatus,a_started,
a_finished,a_due);
commit;
END addMovieTask;
Any help is appreciated ![]() |
|
#2
|
|||
|
|||
|
And what is the error?
|
|
#3
|
||||
|
||||
|
It's ok, I found the error. the "as" on line 2 should not be there. Thanks for replying though... made me remember to look into the user_errors table to see the errrors
![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > problem with stored procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|