OraFAQ Forum: Client Tools » Error while executing the sql query in pl/sql developer

Home » Other » 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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while executing the sql query in pl/sql developer [message #680224]

Wed, 29 April 2020 05:37

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 3297 times)

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Solomon Yakobson
Messages: 3303
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.

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 23:19:52 CST 2025