Source does not have a runnable target.

I get this error when exceuting this pl sql procedure, which compiles good.

what i am doing wrong? the table exists and the query is good
CREATE OR REPLACE
FUNCTION CLIENTESPORCIUDAD(p_ciudad IN VARCHAR2) 
RETURN VARCHAR2 IS
v_numeroClientes number(2);
BEGIN
select count(*) into v_numeroClientes 
from clientes 
where ciudad=p_ciudad;
  RETURN v_numeroClientes;
END CLIENTESPORCIUDAD;

Open in new window

axturAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ivo StoykovCommented:
what is the error?
0
axturAuthor Commented:
it is "Source does not have a runnable target."
0
MarkusIdCommented:
Hi,

You have

RETURN VARCHAR2

but want to return a number (v_numeroClientes).

Try to change the function like that:
CREATE OR REPLACE
FUNCTION CLIENTESPORCIUDAD(p_ciudad IN VARCHAR2) 
RETURN NUMBER IS
v_numeroClientes number(2);
BEGIN
select count(*) into v_numeroClientes 
from clientes 
where ciudad=p_ciudad;
  RETURN v_numeroClientes;
END CLIENTESPORCIUDAD;
 
or
 
CREATE OR REPLACE
FUNCTION CLIENTESPORCIUDAD(p_ciudad IN VARCHAR2) 
RETURN VARCHAR2 IS
v_numeroClientes varchar2(2);
BEGIN
select to_char(count(*)) into v_numeroClientes 
from clientes 
where ciudad=p_ciudad;
  RETURN v_numeroClientes;
END CLIENTESPORCIUDAD;

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ivo StoykovCommented:
you should have some ORA-XXXXX error...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.