Only 3.9% of viewers are subscribing to my channel 😓.
create or replace function refcur_function
(in_actor_id IN numeric, refcur_output refcursor)
returns refcursor
language plpgsql
as $$
begin
open refcur_output for
Select title from film, film_actor
where film.film_id = film_actor.film_id
and film_actor.actor_id = in_actor_id;
return refcur_output;
exception when others then
raise notice 'Something Went Wrong';
end; $$
select refcur_function(1, 'refcur_output');
fetch all in refcur_output;
select refcur_function(2, 'refcur_output');
fetch all in refcur_output;
How To Create And Call A Stored Procedure Function With Refcursor As OUT Parameter In PostgreSQL
,Function With Refcursor OUT Parameter
,Procedure With Refcursor OUT Parameter
,Create A Function With Refcursor OUT Parameter
,Create A Procedure With Refcursor OUT Parameter
,Call A Stored Function With Refcursor OUT Parameter
,PLpgSQL Language
,PostgreSQL PLpgSQL Language
,Refcursor OUT
,Function Refcursor OUT
,Procedure Refcursor OUT
No comments:
Post a Comment