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

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

when MSQL8.0 is in market

0 Answers  

What is the order of sql select?

0 Answers  

Can you have more than one key in a database?

0 Answers  

What does 0 mean in sql?

0 Answers  




how to create temparary sequence

2 Answers   TCS,

What is rule base and cost base optimizer?

2 Answers   Thermotech,

How to update salary of employees department wise?

6 Answers  

What is user define exception and example

1 Answers   HP, KP,

What is sql used for?

0 Answers  

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

Can we rename a column in the output of sql query?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories