Print Thread
otString vs otPLSQLString
#49251 07/21/14 02:16 PM
Joined: Jul 2014
Posts: 19
I
icegood Offline OP
Member
OP Offline
Member
I
Joined: Jul 2014
Posts: 19
Hi there!
Found here that the difference between types is nothing but size. Is situation still same as of y2014? In particular, is it big deal to require every string variable of PL/SQL anonymous block to be otPLSQLString and for every ordinary block to be otString?

Last edited by icegood; 07/21/14 02:35 PM.
Re: otString vs otPLSQLString
icegood #49252 07/22/14 08:59 AM
Joined: Aug 1999
Posts: 22,194
Member
Offline
Member
Joined: Aug 1999
Posts: 22,194
The size is indeed the only difference. If you require more than 4000 bytes of character data to or from your PL/SQL Block, you need to use the otPLSQLString data type.


Marco Kalter
Allround Automations
Re: otString vs otPLSQLString
Marco Kalter #49902 12/17/14 10:30 AM
Joined: Jul 2014
Posts: 19
I
icegood Offline OP
Member
OP Offline
Member
I
Joined: Jul 2014
Posts: 19
It seems to be not only difference frown We've found that otPLSQLString doesn't work with unicode symbols at all frown


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 15 (0.009s) Memory: 2.5023 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-04-16 09:53:41 UTC
Valid HTML 5 and Valid CSS