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 ??
03-30-2001, 02:52 AM
What datatype is "router"?
03-30-2001, 09:38 AM
Thanks for pointing out the error. 'Router' was of numeric dataype.
Now it works fine.