Calling a Function using Execute Procedure throws error - PLS-00221: 'GET_INGESTION_BATCH_ID_FUN' is not a procedure or is undefined

[Bala G]

Hi,

I want to call a Database Function . so am using Execute Procedure for same. But i get error - PLS-00221: 'GET_INGESTION_BATCH_ID_FUN' is not a procedure or is undefined. Below is the screenshot attached. Can you please tel me whats the issue here & how can i call Function ?





Regards,
Bala

[Yavor Nikolov]

For a function you're supposed to also indicate a "?" parameter for the return value: http://dbfit.github.io/dbfit/docs/reference.html#execute-procedure

--
You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+unsubscribe@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.

[Bala G]

Thanks yavor, It worked by adding with ? for output :



Regards,
Bala

On Monday, November 7, 2016 at 4:58:27 PM UTC+5:30, Yavor Nikolov wrote:

For a function you're supposed to also indicate a "?" parameter for the return value: http://dbfit.github.io/dbfit/docs/reference.html#execute-procedure

On Mon, Nov 7, 2016 at 12:40 PM, Bala G <konar....@gmail.com> wrote:

Hi,

I want to call a Database Function . so am using Execute Procedure for same. But i get error - PLS-00221: 'GET_INGESTION_BATCH_ID_FUN' is not a procedure or is undefined. Below is the screenshot attached. Can you please tel me whats the issue here & how can i call Function ?





Regards,
Bala

--
You received this message because you are subscribed to the Google Groups "dbfit" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.