Skip to Main Content

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!

Live SQL Worksheet Error That Wont Clear

02372e11-17fb-48ca-88de-e8b8ef873912Nov 21 2019 — edited Nov 22 2019

Hello - Sorry if this is a simple or repeat question but didn't have much luck looking in the FAQs.

When trying to use the Live SQL Worksheet I get an error that says "1 Error has occurred: PL/SQL: Function returned without value". The worksheet is blank and no code is showing. The bottom of the worksheet page says:

"Invalid Expired

Your session has expired due to inactivity or another reason. If you wish to retain your session SQL, you will need to save your work.
Session Status: ""

Two weeks ago, I entered some basic sample code to test things not intending to save the session. There are no database objects. I've tried to reset the session, deleting old sessions, logging in/out but this error still appears. The error prevents me from entering anything into the worksheet. Currently using Chrome to access the web page if that makes a difference. How do I "reset" the worksheet?

Comments
Post Details
Added on Nov 21 2019
2 comments
948 views