Unanswered: How can I get the dbtimezone when coding PL/SQL?
I want to get the value of dbtimezone in my PL/SQL program. I get an error message which I found very strange. Let me explain it with examples. I wrote the below SQL sentence from SQL PLUS and it works:
SQL> select dbtimezone from dual;
But when I wrote the same sentence in PL/SQL as:
"SELECT dbtimezone INTO v_dbtimezone FROM DUAL;"
I get the following error:
"PLS-00201: identifier 'DBTIMEZONE' must be declared"
I need some explanation about the reason and how I can get the dbtimezone value in PL/SQL block.