CODEWITHSUNDEEP
sqldatabaseoracle-database
124697
124697

Reputation: 21893

How do you call a function in a package via an sql query

I have got a function in PL SQL called FUNCTION names_active(name_entity IN NUMBER) in a package called names_package how can I call it a query

Upvotes: 0

Views: 161

Answers (1)

user330315
user330315

Reputation: 

SELECT names_package.names_active(42) 
FROM dual

More details are in the manual:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_packages.htm#sthref993

Upvotes: 2

Related Questions