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
Messages: 1
Registered: September 2009
Junior Member

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?

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
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
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: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is not Oracle syntax.

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 Oct 25 14:54:29 CDT 2016

Total time taken to generate the page: 0.08066 seconds