Procedure Parameter List [message #686502] |
Wed, 28 September 2022 08:19 |
Duane
Messages: 563 Registered: December 2002
|
Senior Member |
|
|
I have a feeling the answer is going to be No but I thought I would ask anyway in case there is some object that does do this.
Question. Is there an object or way to loop through the parameter list of a procedure? If my procedure has 5 parameters is there a way to loop through all five?
So, you're asking yourself, why would I want to do that? Each parameter has been encoded to Base64 format so I need to convert each one.
procedure FileUpload (Param1 in varchar2,
Param2 in varchar2,
Param3 in varchar2,
Param4 in varchar2,
Param5 in varchar2) is
begin
for i in ParamList
loop
Do something;
end loop;
end;
|
|
|
|
|
Re: Procedure Parameter List [message #686514 is a reply to message #686511] |
Fri, 30 September 2022 14:21 |
Duane
Messages: 563 Registered: December 2002
|
Senior Member |
|
|
I haven't had the time to look into what you are suggesting. I take that back. While in a meeting today, I did look up SYS.ODCIVARCHAR2LIST to see how I could use it. That was it and I had to jump back to the meeting. I'll see if I can look into it next week to see how I can make it work for me.
|
|
|
|
|
|
|