Hi all,
I have an issue similar to
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=46730#Post46730 . I posted a comment on that thread but since i haven't received a response yet i decided to start a new thread. In short my issue is with a procedure that accepts a clob as a parameter. When i am using the test window with a temporary clob variable to pass the parameter in the procedure PSD exhibits the same behaviour as reported by Sachin in the thread above (it seems that the CLOB variable is not stored properly in PSD) . In addition when i try to execute the process i get a lpx-00283(document encoding is UTF-8-based but default input is not) error as well. The xml was retrieved from PSD's large data editor following a call to dbms_xmlgen.getxml on the same database and is around 10kb. To complicate thing even further if i insert the same xml in a db column and select it in a variable and pass it to the procedure then the procedure works fine. Can you please look into this?
To pre-emp the request from support please see below for my configuration parameters
--- Info ---
PL/SQL Developer
Version 10.0.5.1710
12.82854 - 400 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)
Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,861,184 available)
Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True
Preference Files
C:\Users\[username]\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\[username]\AppData\Roaming\PLSQL Developer\Preferences\dkorom\default.ini
Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)
Aliases
ACERD1
ACERD1.WORLD
ACERDEV
ACERDEV2
baltic_BTP1
...
Homes
OraClient11g_home1 (C:\Oracle\product\11.2.0\client_1)
DLLs
C:\Oracle\product\11.2.0\client_1\bin\oci.dll
TNS File
C:\Oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora
Using
Home: OraClient11g_home1
DLL: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Release 11.2.0.3.0
Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 871
Unicode Support: True
NLS_LANG: .AL32UTF8
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: UTF8
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory
SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\Oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = ENGLISH_UNITED KINGDOM.WE8MSWIN1252
OLEDB = C:\Oracle\product\11.2.0\client_1\oledb\mesg
OO4O = C:\Oracle\product\11.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1
SQLPATH = C:\Oracle\product\11.2.0\client_1\dbs
MSHELP_TOOLS = C:\Oracle\product\11.2.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\11.2.0\client_1\oo4o
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\Oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
--- Path ---
C:\Oracle\product\11.2.0\client_1\bin
C:\Program Files\Dell\DW WLAN Card
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86
C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64
C:\Program Files\TortoiseSVN\bin
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
C:\Program Files (x86)\HP\LoadRunner\strawberry-perl\perl\bin
--- TNS names ---
### omitted
