I have a function called
get_pid in a file called
func.sql . The function
get_id takes an
given_price Parts.price%type and returns an integer.
To call this function, I created a new file called
main.sql. Then I login to sqlplus and I call main in this way:
select get_pid(400) from dual
ERROR at line 1:
ORA-00904: "GET_PID": invalid identifier
Am I calling the function properly? What could possibly be wrong, I looked at the other questions posted about this topic, but I can't figure out what I am doing wrong.
Try to inform the name of the scheme where are your function.
for example, the username (schema) is dev, then you have to try like this.
select dev.get_pid(400) from dual.
when you are on prompt you always have to use the scheme name "." your function/procedure.