Error while executing the sql query in pl/sql developer [message #680224] |
Wed, 29 April 2020 05:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d0bc83599941e1a0c5c403ccb27353dc?s=64&d=mm&r=g) |
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
|
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|
|
|
|