Can we call user defined packages in SQL statements?

Questions by sai_yeddula

Showing Answers 1 - 5 of 5 Answers

poornima

  • Dec 14th, 2005
 

no we won't use user defined pac kages in sql

  Was this answer useful?  Yes

sumit01_77

  • Jan 21st, 2006
 

I do not agree that we can't call user defined packages in the SQL statements.

Instead we can call user defined packaged functions in the SELECT statement.

e.g. SELECT pkg.test(10) FROM DUAL;

apiplani

  • Feb 12th, 2006
 

Yes you can call user defined packages and functions in SQL. Of course you do need to take care that you pass the right arguments to it

  Was this answer useful?  Yes

Mainak Aich

  • Mar 17th, 2006
 

Hi,Everyone forgot to point out 1 thing,which is most essential to use a user defined package which is he/she must have the execute permission to use the package if he/she is not the creator of that package.If it is ok definitely an user defined package can be used.

  Was this answer useful?  Yes

FALAK

  • Apr 25th, 2006
 

a user defined package can be invoked in sql only if we r using it to call public functions or variables.but packaged procedures can not be called from sql

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions