for function select package.funtname(parameter) from dual/table; for

How to get the procedure's, function's name from a package
if it is wrapped(both spec & body).

Question Posted / kart

Answer Posted / kart

for function

select package.funtname(parameter) from dual/table;

for procedure

exec packagename.procedurename(parameter);

u cant call the trigger

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to combine two stored procedures in sql?

1234

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1000

What is a primary key example?

956

What are the types of queries in sql?

1086

What are different types of triggers?

1110

Does pl sql work in mysql?

980

What is sqlservr exe?

975

How to add new employee details in an employee_details table with the following details

1091

What is group by in sql?

1083

What do you understand by pl/sql records?

1018

Why do we use %rowtype & %type in plsql?

1048

What does := mean in pl sql?

1042

What is PL/SQL Records?

1189

What is type and rowtype in pl sql?

1014

Is keyword pl sql?

997