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 ??
What datatype is "router"?
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Thanks for pointing out the error. 'Router' was of numeric dataype.
Now it works fine.
Click Here to Expand Forum to Full Width