dave.abbot
Member
The parameters for plsql procedures and functions are not properly returned in plsqldev 7.1 when working against and Oracle 7 database.
e.g.
begin
-- Call the function
:result := pck_balance.get_jumbo(彉呓剁彔䅄䕔 for % => :彉呓剁彔䅄䕔 for %,
彉久彄䅄䕔t for => :彉久彄䅄䕔t for,
彉䵐低ipt => :彉䵐低ipt);
end;
I have tried disabling unicode support with no success.
PL/SQL Developer
Version 7.1.0.1337
41412 - 10 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 253,424 kB (54,496 available)
Paging file : 1,001,912 kB (729,904 available)
Virtual memory : 2,097,024 kB (2,004,060 available)
Parameters
E:\AllroundAutomations\PLSQLDeveloper\plsqldev.exe
Preferences
Session mode: Dual
OCI Library:
Use OCI7: True
Preference Files
E:\AllroundAutomations\PLSQLDeveloper\Preferences\Default\Default.ini
E:\AllroundAutomations\PLSQLDeveloper\Preferences\DaveA\default.ini
Plug-Ins
*Active Query Builder (E:\AllroundAutomations\PLSQLDeveloper\PlugIns\ActiveQueryBuilder.dll)
(* is Active)
Aliases
CKFP
DEV
KAP1
KND1
KND1.MSHOME.NET
...
Homes
OraHome90 (E:\oracle\ora90)
DLLs
E:\oracle\ora90\bin\oci.dll
TNS File
E:\oracle\ora90\Network\Admin\tnsnames.ora
Using
Home: OraHome90
DLL: E:\oracle\ora90\bin\oci.dll
OCI: Version 9.0
Oracle7 Server Release 7.3.4.5.0
Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 0
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: WE8ISO8859P1
e.g.
begin
-- Call the function
:result := pck_balance.get_jumbo(彉呓剁彔䅄䕔 for % => :彉呓剁彔䅄䕔 for %,
彉久彄䅄䕔t for => :彉久彄䅄䕔t for,
彉䵐低ipt => :彉䵐低ipt);
end;
I have tried disabling unicode support with no success.
PL/SQL Developer
Version 7.1.0.1337
41412 - 10 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 253,424 kB (54,496 available)
Paging file : 1,001,912 kB (729,904 available)
Virtual memory : 2,097,024 kB (2,004,060 available)
Parameters
E:\AllroundAutomations\PLSQLDeveloper\plsqldev.exe
Preferences
Session mode: Dual
OCI Library:
Use OCI7: True
Preference Files
E:\AllroundAutomations\PLSQLDeveloper\Preferences\Default\Default.ini
E:\AllroundAutomations\PLSQLDeveloper\Preferences\DaveA\default.ini
Plug-Ins
*Active Query Builder (E:\AllroundAutomations\PLSQLDeveloper\PlugIns\ActiveQueryBuilder.dll)
(* is Active)
Aliases
CKFP
DEV
KAP1
KND1
KND1.MSHOME.NET
...
Homes
OraHome90 (E:\oracle\ora90)
DLLs
E:\oracle\ora90\bin\oci.dll
TNS File
E:\oracle\ora90\Network\Admin\tnsnames.ora
Using
Home: OraHome90
DLL: E:\oracle\ora90\bin\oci.dll
OCI: Version 9.0
Oracle7 Server Release 7.3.4.5.0
Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 0
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: WE8ISO8859P1