How to ignore empty parameter in a Sored Procedure Oracle

Vote count: 0

I have created a stored procedure where the user can inset 1 or multiple values in the parameter

create or replace procedure  MyProcerdure
(
title Film.Title%Type,
country Film.country%Type,
language  Film.language%Type,
category  Film.category%Type,
refCursor OUT SYS_REFCURSOR ) 
AS 
begin 
 OPEN refCursor FOR
select Film.Title as FilmTitle,
      Film.language as language
       Film.category

FROM Film 
Where Film.language=language
AND Film.category=category
AND Film.Country=country
//etc...

But I want to allow the fact that the user doesn't have to fill them all and pass them in parameter , which means if the user only enter the language without anything else , return the proper language , and let's say he entered country and language so the result should get WHERE language and country is equal to what he inserted

Is it possible to make such a mechanism in a stored procedure using oracle ?

Thank you

asked 33 secs ago

napi15

Let's block ads! (Why?)

How to ignore empty parameter in a Sored Procedure Oracle