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

DGM-17000: More than one instances have name "string".

1 Answers  


ORA-38901: column "string" of table "string" must be one of the first "number" columns

1 Answers  


ORA-07470: snclget: cannot get cluster number.

1 Answers  


ORA-16231: DDL barrier

1 Answers  


PCC-00129: Option "string" must be given

1 Answers  






IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  


ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.

1 Answers  


ORA-22627: tc [string] must be that of object/varray/nested table

1 Answers  


NNO-00057: loading and verifying topology data

1 Answers  


ORA-27209: syntax error in device PARMS - unknown keyword or missing =

1 Answers  


PCC-00119: Value of const variable in INTO clause will be modified

1 Answers  


ORA-13055: Oracle object string does not exist in specified table

1 Answers  


Categories