TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Anjali Khan
NA
867
224.5k
created procedure but getting error ?
Feb 7 2017 5:33 AM
hi frnds
I created procedure using oracle data base.
here I am using 3 tbles where I want to insert the data using 3 tables I created this but getting error
I am sharing the code please let me know where I did mistake I checked by internet but not getting solution
CREATE OR REPLACE PROCEDURE PROC_INSERT_RECORD
(
P_PROJ_ID VARCHAR2, (table1)
P_ASSIGNEDTO VARCHAR2,
P_DUE_DT VARCHAR2, (table 2)
P_PROB_STATEMENT VARCHAR2 (table 2)
)
AS
BEGIN
--add Record.
INSERT INTO App_UsER (PROJ_ID, ASSIGNEDTO, DUE_DT, PROB_STATEMENT)
VALUES(P_PROJ_ID, P_ASSIGNEDTO, P_DUE_DT, P_PROB_STATEMENT);
COMMIT;
END PROC_INSERT_RECORD;
Reply
Answers (
1
)
How to get time wise sales report in mysql
how to insert data using oracle data base in mvc ?