PCB-00242: A host variable or exact numeric constant is
required here



PCB-00242: A host variable or exact numeric constant is required here..

Answer / guest

Cause: The particular item in the dynamic SQL statement is
required to be a host variable or exact numeric (integer)
constant, but is not.

Action: Change the item in the dynamic SQL statement to use
a host variable or exact numeric constant. "300 - 399: FIPS
flagging error messages."

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32166: Cannot get XA connection

1 Answers  


ORA-02854: Invalid number of request buffers

1 Answers  


ORA-25247: %s is not a recipient of specified message

1 Answers  


ORA-12227: TNS:syntax error

1 Answers  


PLS-00166: bad format for date, time or timestamp literal

1 Answers  






ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

1 Answers  


NID-00121: Database should not be open

1 Answers  


ORA-25237: navigation option used out of sequence

1 Answers  


KUP-03015: OCI error getting datetime lfprecision.

1 Answers  


RMAN-06486: changed backup piece expired

1 Answers  


ORA-24384: Application context size is not initialized

1 Answers  


ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 Answers  


Categories