ORA-06553: PLS-306: wrong number of types of arguments Options

[urbuddie]

I'm trying to call a custom made PL/SQL function in a SQL query. I want to supply the values of the parameters during the query. I can call the function if I "hard code" the parameter values, but when I try to supply them I get the ORA-06553 error.

This call works:
select pkg_tm_import_util.wb_screen_hr_refresh_func('','','','','','','','','','','','') from dual

However, this does not, but should be the same as the call that works:
select pkg_tm_import_util.wb_screen_hr_refresh_func(
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''''
) results
from dual

Any pointers are appreciated.

[HAL9000]

"ORA-06553: PLS-306: wrong number of types of arguments"

It says what it means and it means what it says, you are not supplying the right number of arguments!

You are cnfusing concatenation marks, which are for dynamic SQL with a call.

CODE

select 'select * from '||table_name||';' from user_tables;

Try this with "execute immediate"


runme := 'select pkg_tm_import_util.wb_screen_hr_refresh_func('||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''','||
''''''
');'

execute immediate runme

See here for working examples:

http://www.dba-oracle.com/t_oracle_execute_immediate.htm