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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

511


Does sql backup shrink transaction log?

543


How do you optimize a query?

524


What is output spooling in sql*plus?

539


Is sql a case sensitive language?

504






how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

760


How do I count duplicates in sql?

534


List and explain the different types of join clauses supported in ansi-standard sql?

802


What is difference between hql and sql?

493


What is the need of a partition key?

524


How to place comments in pl/sql?

592


What is cursor in pl sql with examples?

469


What types of commands can be executed in sql*plus?

538


What is a left join?

493


what does the t-sql command ident_incr does? : Transact sql

589