OPEN-FOR, varchar and nvarchar (more questions)
542526May 6 2009 — edited May 6 2009hello
create or replace function fnEnumSystemUser
+(+
+FirstNameFilter nvarchar2,+
+...+
+)+
RETURN xxxxx.cursorType /* REF-CURSOR */
AS
+strSQL varchar(2000);+
SystemUserCursor xxxxxcursorType;
BEGIN
+...+
+open SystemUserCursor FOR strSQL using FirstNameFilter;+
+...+
Notice that FirstNameFilter type = nvarchar2 and strSQL type=varchar - if "FirstNameFilter" contains Asian character, then I presume it'd become jibberish in "strSQL"? And also lost any unicode data in OPEN-FOR operation?
(Actually I don't know what exactly will happen, at least not until I test with the app which is not yet read. And you can't call the function with unicode character with TOAD and didnt manage to get around test this with SQL*Plus yet.)
Thanks