Ilegal Variable Name

[Ajay Bhosle]

I am executing the below query with a Bind Variable. It gives me an error ORA-01036.

ALTER PROFILE CM_PROFILE LIMIT PASSWORD_LOCK_TIME :Val2;

Is it that we cannot use bind variables for such queries.

Thanks
Ajay.

 

[Jens Fudickar]

I think so.

Normaly bind variables can only be used for dml statements.

This is a ddl-statement, and there by default a bind is not usable.

Greetings
Jens

 

[Marco Kalter]

You will need to use a substitution variable instead (otSubst).