Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release



PLS-00960: RPCs cannot use variables with schema level user-defined types in this release..

Answer / guest

Cause: Schema level user-defined types, or types which
recursively use such types, cannot be used in RPCs. For
example: create type foo as object (...) create package
my_pack is type my_tab is table of foo; -- on a remote
server: x my_pack.my_tab@rpc; -- illegal attempt to use type
my_tab

Action: Use only PLSQL defined types for RPC calls. It may
be necessary to add extra code to element-wise copy
top-level types into local types in order to move such data
through an RPC.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PROT-00015: Unimplemented feature

1 Answers  


NNL-00935: Requests refused, SINGLE-VALUE violation: number

1 Answers  


ORA-23290: This operation may not be combined with any other operation

1 Answers  


ORA-33425: (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.

1 Answers  


NNL-00970: System query index number: number

1 Answers  


ORA-39303: schema sync/swap operation fail because of confilcts

1 Answers  


ORA-06001: NETASY: port set-up failure

1 Answers  


ORA-30032: the suspended (resumable) statement has timed out

1 Answers  


SQL*Loader-00270: TERMINATED BY EOF valid only for CHAR or RAW datatypes

1 Answers  


QSM-01103: there is a remote table, string, referenced in the query

1 Answers  


IMP-00079: Warning: National character set data in this table may be incorrect

1 Answers  


RMAN-08514: archive log filename=string recid=string stamp=string

1 Answers  


Categories