plsql related issue
Database
1
Posts
1
Posters
0
Views
1
Watching
-
create or replace FUNCTION Activation2(v_status OUT varchar,v_status1 OUT varchar) returns setof sc_register AS $$ declare begin SELECT st_value into v_status FROM sc_activation_dtls WHERE si_slno = 2; select * from sc_register ; end; $$ LANGUAGE 'plpgsql' VOLATILE aftr writng above plsql functiopn in postgresql pane m getting follwing error function result type must be record because of OUT parameters doest it mean that we cant use output parameter and return statent togather. since my requirement is to get some value of table through output parameters along with records of different table ..in one function only. Thanks