ORA-06504: PL/SQL: Return types of Result Set variables or
query do not match



ORA-06504: PL/SQL: Return types of Result Set variables or query do not match..

Answer / guest

Cause: Number and/or types of columns in a query does not
match declared return type of a result set variable, or
declared types of two Result Set variables do not match.

Action: Change the program statement or declaration. Verify
what query the variable actually refers to during execution.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23305: internal deferred RPC error: string

1 Answers  


ORA-01341: LogMiner out-of-memory

1 Answers  


TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  


ORA-13900: missing or invalid parameter string

1 Answers  






ORA-07685: sou2os: supervisor stack set error

1 Answers  


RMAN-06094: datafile string must be restored

1 Answers  


ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  


RMAN-06070: DBWR could not identify datafile string

1 Answers  


TNS-00006: INTCTL: HOST variable is not defined

1 Answers  


ORA-12089: cannot online redefine table "string"."string" with no primary key

1 Answers  


DRG-12405: error occurred processing CTX REDIRECT or CTX LABEL tag

1 Answers  


Categories