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

In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue

2 Answers  


ORA-08456: no sign in picture mask but SIGN clause in mask options

1 Answers  


ORA-06108: NETTCP: connect to host failed

1 Answers  


ORA-29961: too many warnings occurred in the execution of ODCIIndex DDL routine

1 Answers  


ORA-02277: invalid sequence name

1 Answers  






PLS-00734: Illegal use of an associational parameter with a formal ellipsis

1 Answers  


PCB-00235: Table size mismatch in INTO/USING. Minimum is: number

1 Answers  


RMAN-04015: error setting target database character set to string

1 Answers  


ORA-23337: priority or value not in priority group string

1 Answers  


ORA-30121: 'string' is not an allowable value for 'string'

1 Answers   CTS,


IMG-00840: image structure allocation failed

1 Answers  


RMAN-06428: recovery catalog is not installed

1 Answers  


Categories