Home » SQL & PL/SQL » SQL & PL/SQL » REF CURSOR with NVARCHAR2 data type (Oracle 10g)
REF CURSOR with NVARCHAR2 data type [message #421041] Thu, 03 September 2009 16:27 Go to next message
muralip
Messages: 1
Registered: September 2009
Junior Member
Hello,

I have a stored procedure that uses a REF CURSOR to execute a dynamic SQL. Now, As we need to support unicode, I need to change a p_sql_txt parameter of the procedure to nvarchar2 from varchar2.
Now, when OPEN <REF CURSOR> FOR @P_SQL_TXT is executed inside the procedure- Getting an error. After some digging, I found that REF CURSOR do not support NCHAR, NVARCHAR2 data types.

Can someone pl suggest an alternative?

Thanks
M
Re: REF CURSOR with NVARCHAR2 data type [message #421043 is a reply to message #421041] Thu, 03 September 2009 17:02 Go to previous messageGo to next message
BlackSwan
Messages: 24908
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: REF CURSOR with NVARCHAR2 data type [message #421059 is a reply to message #421041] Fri, 04 September 2009 00:44 Go to previous message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
OPEN <REF CURSOR> FOR @P_SQL_TXT

This is not Oracle syntax.

Regards
Michel
Previous Topic: creating a gap in rec_nos
Next Topic: Help In Oracle SQL in converting GMT to EST with DST and Date Offset
Goto Forum:
  


Current Time: Tue Sep 27 14:31:08 CDT 2016

Total time taken to generate the page: 0.07112 seconds