Does it possible to pass object (or) table as an argument
to a remote procedure?



Does it possible to pass object (or) table as an argument to a remote procedure?..

Answer / gogu s k

It is possible to pass table as argument to a procedure. This
feature used with Dynamic sql along ref cursor concept.In
dataware house environment tables are passed as argument to
procedures.

Is This Answer Correct ?    16 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  


What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,


Are stored procedures faster than queries?

0 Answers  


what is “go” in t-sql? : Transact sql

0 Answers  






what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  


Why do we need sharding?

0 Answers  


What are triggers and its types?

0 Answers  


What does “select count(1) from tab” result?

9 Answers   IBM,


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


How to make a copy values from one column to another in sql?

0 Answers  


How to add a column ‘salary’ to a table employee_details?

0 Answers  






Categories