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

Post New Answer




More SQL PLSQL Interview Questions

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

0 Answers  


What is the difference between SQL and PLSQL

4 Answers   IBM,


Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,


What is normalization? dec 2009

3 Answers   Cognizant,


sql query to get zero records from a table having n no of records

8 Answers   CTS,






how will i became good database developer?

1 Answers  


When do we create bitmap indexes

2 Answers   CTS,


Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,


Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  


Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,


what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,


What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Polaris, Metric Stream,






Categories