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

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,


What is an Exception ? What are types of Exception ?

2 Answers  


When the mutating error will comes? and how it will be resolved?

2 Answers  


what is explain plan?

4 Answers  


Can a procedure in a package be overloaded?

0 Answers   EXL,






Write a query to find second highest salary of an employee.

27 Answers  


What is Difference Between delete and Truncate?

9 Answers  


IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

7 Answers   rsystems,


in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,


What is an intersect?

0 Answers  


Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,






Categories