For some reason, I need a query that builds all the input parameters of a given procedure along with their values in one string, the query should work with any procedure regardless of the number of the input parameters.
For example I have such a procedure:
create or replace procedure mytest (par1 varchar(10) , par2 varchar(10), par3 int)
result (ss long varchar)
begin
select ‘how can i write this?’
end;
And my call looks like this:
select * from mytest(‘abc’, null, 3)
Then I expect the result like this:
par1=’abc’, par2=null, par3=3
For some reason, I need a query that builds all the input parameters of a given procedure along with their values in one string, the query should work with any procedure regardless of the number of the input parameters.For example I have such a procedure:create or replace procedure mytest (par1 varchar(10) , par2 varchar(10), par3 int)
result (ss long varchar)
begin
select ‘how can i write this?’
end;And my call looks like this:select * from mytest(‘abc’, null, 3) Then I expect the result like this:par1=’abc’, par2=null, par3=3 Read More Technology Blog Posts by Members articles
#SAP
#SAPTechnologyblog