CODEWITHSUNDEEP
plsqloracle11gplsqldeveloper
Justin Russo
Justin Russo

Reputation: 339

executing an oracle package function

Hi i have an oracle function already present in the database which i have to use. if i call the function as below it works fine

select PKG_Util.employeedetails('12345') from dual;

But if i try to pass in multiple identifiers, this statement doesnt execute

select PKG_Util.employeedetails(select id from dbo.emp_details) from dual;

i understand that dual would output only one row.

But is there any other way i can pass multiple rows on emp id's to execute the function-package and get the output.

thanks

Upvotes: 3

Views: 4640

Answers (1)

Randy
Randy

Reputation: 16673

select PKG_Util.employeedetails(id) from dbo.emp_details;

Upvotes: 4

Related Questions