Click to See Complete Forum and Search --> : PLS-00306 Error


rshivagami
03-29-2001, 06:41 PM
Hi all,

I get the error
Line # = 19 Column # = 24 Error Text = PLS-00306: wrong number or types of arguments in call to '||'
Line # = 20 Column # = 9 Error Text = PLS-00306: wrong number or types of arguments in call to 'INSTR'

where my line 19 & 20 are is
dbms_output.put_line('router = ' || router);
a := instr(router,'-');

I have used these commands hundreds of times before, but have never seen this. Does anyone know what might be causing this error ??

Shiva.

jmodic
03-30-2001, 03:52 AM
What datatype is "router"?

rshivagami
03-30-2001, 10:38 AM
Thanks for pointing out the error. 'Router' was of numeric dataype.
Now it works fine.