Test Window--using rowtype parameters

[Renee]

Hi,

I looked through searches and found some a decade old that say this isn't possible--hopefully that isn't still true.

I have a function that takes input parameters of %ROWTYPE and a NUMBER--it returns a NUMBER.

I would like to open a test window and walk through the code. I need to know what I should enter as that parameter value on the test window.

For example, for the number I enter 10 for the value--but what to put for %ROWTYPE. I tried using 'PLSQL String' from the type dropdown with no success. I also tried just leaving it as string. I thought maybe 'Temporary CLOB'. Maybe one of those is correct and I just don't know the proper value format.

Thanks
Renee

 

[Jens Naumann]

Hi, this is easy done. You can't use bindvaribles for that. Just create a local variable and fill it. dba_tables is an Oracle View as an example.

Regards

declare
l_record dba_tables%rowtype;
begin
l_record.owner := 'SOMEONE';
l_record.TABLE_NAME := 'SOMETABLE';
-- and so on

-- call the methode
mymethod(l_record);

end;