How to run a package from Oracle SQL Worksheet

[Birjot]

Hi,

I am trying to run the package FND_REQUEST.SUBMIT_REQUEST from Oracle SQL Worksheet using the following statement:

execute FND_REQUEST.SUBMIT_REQUEST(...)

but I get the following error:

ORA-06550: line 2, column 2:
PLS-00221: 'SUBMIT_REQUEST' is not a procedure or is undefined
ORA-06550: line 2, column 2:

Can any one pl tell me the reason and how to run it properly.

Thanks in advance
Birjot

 

[krazyivan]

1-check user
you should be same db user or any user with exec priv.

2-if FND_REQUEST is a package
check SUBMIT_REQUEST in package spec
to be in package body is not enough for running

waiting for your comment.