Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / suji


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 ?    18 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is julian date in oracle

2 Answers  

What are schema-level triggers?

0 Answers  

explain mysql aggregate functions. : Sql dba

0 Answers  

How to call DDL statements from pl/sql?

5 Answers  

Explain the uses of a database trigger?

0 Answers  




What are the sql aggregate functions?

0 Answers  

What is sql*loader?

0 Answers  

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

2 Answers  

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

Does normalization improve performance?

0 Answers  

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

What is primary key in db?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories