Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> ORA-06553: PLS-306: wrong number of types of arguments
urbuddie
post Apr 9 2012, 10:57 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 9-April 12
From: O'Fallon IL
Member No.: 47,058



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.
Go to the top of the page
 
+Quote Post
HAL9000
post Apr 9 2012, 05:43 PM
Post #2


Advanced Member
***

Group: Members
Posts: 876
Joined: 25-September 07
Member No.: 12,336



"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



Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd April 2014 - 02:30 PM