nkacharani — 2012-04-27T05:44:11-04:00 — #1
can someone assist what am I doing wrong!..
I have two tables shop and shop_owner I want to have a procedure which will be adding shops to the mall(if owner open a new shop)
CREATE PROCEDURE update_mall
declare @man varchar(30);
select * from shop_owner where owner_Id = 'MAN001' //assuming MAN001 is the ID admin enter in search box
set @man = 'MAN001'
insert into shop (owner_Id,shop_name,shop_location) values
('MAN001','Shine and smile','Kariakoo');
r937 — 2012-04-27T05:54:57-04:00 — #2
what you're doing wrong is not telling us how you know that what you're doing is wrong
what happens when you run that procedure? does it crash? return the wrong data? produce an error message?
nkacharani — 2012-04-27T06:01:03-04:00 — #3
lol!..I do not see the insert part working(if I select all in the shop table no data is added) though the query execute successful
timu123 — 2012-05-02T07:23:10-04:00 — #4
Procedural language is the concluding part of sql oracle and it is very beneficial when storing a value into the database, moreover its secured and safe to keep it safe.
r937 — 2012-05-02T08:02:10-04:00 — #5
looks like english, sounds like english, but what the heck does it mean?