SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set statement_timeout by SQL

719645Jun 8 2012 — edited Jun 8 2012

Hi!

I'm a newbie in Oracle and i'd like to know the SQL to set the statement_timeout.
I tried the following SQL: ALTER ROLE abcd SET statement_timeout = 1000 but this instruction caused an ORA-00922: missing or invalid option error.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2012

Added on Jun 8 2012

4 comments

8,305 views