Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Oracle PL/SQL

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Monday, 19 August 2019 15:27 PM UTC

HELP!

When we "upgraded" to Oracle 12C from Oracle 11g several years ago, we started seeing the following EVERY. SINGLE. TIME. we connected to a database in both SQL+ and when running a script in SQL+.

We use standard PL/SQL and run the scripts in SQL+.

This occurs even when the script has NO "Set" commands included.

Can anyone tell me how to turn off these two things/prevent them from being generated or displayed:

   1)  SP2-0158:  unknown SET option "set"

   2) Tracefile will be: D:\APP\ORAADMIN01\PRODUCT\12.1.0\DBHOME_1\RDBMS\TRACE\sbtrn12d_ora_13508.trc
       D:\APP\ORAADMIN01\PRODUCT\12.1.0\DBHOME_1\RDBMS\TRACE\sbtrn12d_ora_13508.trc


   I have scoured the internet for a solution to either issue, to no avail.


Thank You,

Olan

DDDW with values based on another column
Decimal to Formatted String
Responses (2)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Tuesday, 20 August 2019 10:39 AM UTC
  2. PowerBuilder
  3. # 1

Hi Olan,

I think SP2 is an SQLPlus error message.

there is somewhere a SQLPlus SET command. From error message it must be a command that starts with

"SET set".

If there is no such command in your script I guess that you use some automatic script like a login script that is not ok? (https://docs.oracle.com/cd/B28359_01/server.111/b31189/ch2.htm)

 

HTH,

René

Comment
Olan Knight
  1. Olan Knight
  2. Tuesday, 20 August 2019 13:34 PM UTC
Thanks, Rene!

I am manually writing these scripts in Notepad++, and the error occurs even when there are ZERO "Set" commands in the script. It's bizarre.



Olan
  1. Helpful
René Ullrich
  1. René Ullrich
  2. Tuesday, 20 August 2019 13:38 PM UTC
Hi Olan,

if there are no login scripts that runs automatically I don't know what it could be.
  1. Helpful
There are no comments made yet.
Mark Lee @Appeon
Mark Lee @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 20 August 2019 09:58 AM UTC
  2. PowerBuilder
  3. # 2

Hi Olan,

 

Sorry that i haven't encountered this issue before.

Can you find the old install path(Oracle 11g) in the Path in the System variables of the Environment variables? If yes, please delete it and restart the compute and try again. Hope this can resolve your problem.

Regards,

 

Comment
Olan Knight
  1. Olan Knight
  2. Tuesday, 20 August 2019 13:37 PM UTC
Thanks and good call, Mark!

As it turns out I have an Oracle 11g client connecting to Oracle 12C databases. Let me check how the Oracle 12 client behaves!



Olan
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.