Home » SQL & PL/SQL » Client Tools » Error while executing the sql query in pl/sql developer (12.2.0.1.0 of oracle, pl/sql Developer version - 7.1.1.1)
Error while executing the sql query in pl/sql developer [message #680224] Wed, 29 April 2020 05:37 Go to next message
sasank325@gmail.com
Messages: 2
Registered: April 2020
Junior Member
Hi Everyone,

I am facing the error while executing the sql query in pl/sql developer. below is the query which

i had executed.

select unwrap_code ('utpks_utdfndrl', 'package body') from dual

Below is the error msg:

"A query with LOB's requires OCI8 mode, But OCI7 mode is used"

Please help me to resolve the issue, i had searched and got the link, but the link which was posted in orafaq is not opening.

Thanks
Sasank

  • Attachment: Error_Msg.doc
    (Size: 22.21KB, Downloaded 101 times)
Re: Error while executing the sql query in pl/sql developer [message #680226 is a reply to message #680224] Wed, 29 April 2020 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is "unwrap_code"? A PL/SQL procedure or an external program?
What is the version of the client?
Post the result of "select * from v$version".
The error seems to indicate you used an old version of Oracle client. Which one is it?

Note: I didn't open you "doc" file, few of us wants to open a file which can contain a virus.
Post what you want to show inside the post itself.

[Updated on: Wed, 29 April 2020 06:12]

Report message to a moderator

Re: Error while executing the sql query in pl/sql developer [message #680227 is a reply to message #680224] Wed, 29 April 2020 06:38 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2985
Registered: January 2010
Location: Connecticut, USA
Senior Member
It means procedure unwrap_code returns CLOB while you are using very old SQL*Developer version that can't handle LOBs. You either need to use SQL*Plus, or get more recent version or read unwrap_code ('utpks_utdfndrl','package body') in PL/SQL using DBMS_LOB.SUBSTR in 32K chunks).

SY.
Re: Error while executing the sql query in pl/sql developer [message #680246 is a reply to message #680226] Thu, 30 April 2020 04:36 Go to previous messageGo to next message
sasank325@gmail.com
Messages: 2
Registered: April 2020
Junior Member
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Re: Error while executing the sql query in pl/sql developer [message #680249 is a reply to message #680246] Thu, 30 April 2020 05:12 Go to previous message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about the other points?
What about what Solomon said?

Previous Topic: Bug in SQL*Plus "spool" command?
Next Topic: Client fails to connect to new DB server with "TNS-03505: Failed to resolve name"
Goto Forum:
  


Current Time: Fri Sep 18 15:33:10 CDT 2020