I am attempting to create a logon procedure using Oracle Express 11g in PL/SQL. I would like to develop a procedure named MEMBER_CK_SP that accepts the ID and password as inputs, checks whether they make up a valid logon, and returns the member name and cookie value. Return the name as a single text string containing the first and last name, separated by a space.

I need parameters minimized so use the same parameter to accept the password and return the name value. If the user does not enter a valid username and password, return the value INVALID in a parameter named p_check. If valid, return VALID in that parameter. Parameters should be in the order of username, password, cookie, and valid.

Also, create an SQL script, test_member_valid_pw, to test the procedure using a valid logon first, passing the username rat55 as a string for the first parameter and using the password kile. 

 

Use the following DECLARE:
DECLARE
  lv_pass_txt VARCHAR2(30) := 'kile';
  lv_cook_num bb_shopper.cookie%TYPE;
  lv_chk_txt VARCHAR2(7);

 

Use the following to display your output:
  DBMS_OUTPUT.PUT_LINE('Password = ' || lv_pass_txt);
  DBMS_OUTPUT.PUT_LINE('Cookie number = ' || lv_cook_num);
  DBMS_OUTPUT.PUT_LINE('Valid? = ' || lv_chk_txt);

Next, create an SQL script, test_member_invalid_pw, to test the procedure using an invalid logon by changing the username to rat. Use the same DECLARE as above.

My table is titled BB_SHOPPER - see attached image for columns and data information.

• 1493701951-image2.PNG
• 1493701952-image1.PNG

ComputerScienceExpert

(11)

Status NEW Posted 02 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1493701956-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer