当前位置: 动力学知识库 > 问答 > 编程问答 >

oracle - PL/SQL function return type integer : Invalid Identifier

问题描述:

I have a function called get_pid in a file called func.sql . The function get_id takes an

input: 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:

SQL> @Q1_main

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: