Examine this table in the SH schema: Now, examine this code: Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
A.
In line 1, change IN OUT mode to IN mode.
B.
In line 2, change IN OUT mode to IN mode.
C.
In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
D.
In line 1, add the default parameter DEFAULT 2000.
E.
In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F.
In line 2, add the default parameter DEFAULT 2000.
Only IN type parameter can take default value, parameterized cursors only can execute with IN parameters.
Answer B+F its correct
--correct
create or replace procedure proc1 (p1 in number default null) is
cursor c_emp(p_employee_id number default 20000)
is
select * from employees where employee_id = p_employee_id;
begin
dbms_output.put_line('error');
open c_emp(100);
end;
I mean as the other guy says this works without changing anything
But since you're not modifying the p_pdt_price just keep it as in. And also not like you're gonna change the cursor parameter so also keep it as in
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
abdullah_barham
Highly Voted 1 year, 4 months agoerykjuarez
Most Recent 5 months agothranduyl
8 months agoegznrd
10 months, 3 weeks agoTheOracleWasTaken
11 months agoGoto10
1 year, 1 month agosorincirnu
1 year, 2 months ago