in pl /sql the commend is like this create table bb_basketstatus (idstatus number, idbasket number, idstage number, dtstage date, shipper varchar(200),shippingnum varchar(299)); create sequence bb_status_seq start with 1 increment by 1; create or replace procedure STATUS_SHIP_SP ( p_basketID Number,p_datestage DATE, p_shipper varchar, p_shippingnum varchar) as begin INSERT INTO bb_basketstatus (idstatus, idbasket, idstage, dtstage, shipper, shippingnum) values (bb_status_seq.NEXTVAL,p_basketID,3,p_datestage,p_shipper,p_shippingnum); commit; end; / select From bb_ basketstatus; Execute status_ship_sp(3,'20-FEB-12','UPS','ZW2384YXK4957') ---- why it only shows " PL/SQL procedure successfully completed."without showing the result of database ?
in pl /sql the commend is like this
create table bb_basketstatus (idstatus number, idbasket number, idstage number, dtstage date, shipper varchar(200),shippingnum varchar(299));
create sequence bb_status_seq start with 1 increment by 1;
create or replace procedure
STATUS_SHIP_SP
( p_basketID Number,p_datestage DATE, p_shipper varchar, p_shippingnum varchar)
as
begin
INSERT INTO bb_basketstatus (idstatus, idbasket, idstage, dtstage, shipper, shippingnum)
values (bb_status_seq.NEXTVAL,p_basketID,3,p_datestage,p_shipper,p_shippingnum);
commit;
end;
/
select From bb_ basketstatus;
Execute status_ship_sp(3,'20-FEB-12','UPS','ZW2384YXK4957')
----
why it only shows "
PL/SQL procedure successfully completed."without showing the result of
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)