Home » SQL & PL/SQL » SQL & PL/SQL » non restrictive ref cursor
non restrictive ref cursor [message #37049] Fri, 11 January 2002 20:04 Go to next message
Amit Jani
Messages: 1
Registered: January 2002
Junior Member
I am using non restrictive ref cursor (Weak cursor) because I have to open cursor with dynamic sql.This type of pl/sql code works fine on my linux 7.1 with Oracle 8.1.7 but it gives me end-of-file communication chhanle erro on Solaris Sparc with oracle 8.1.7 and Windows NT with same oracle version.
Its neccessary for me to use dynamic sql to open cursor so I have to use non restrictive cursor.
Is there any OS parameter setting or Database parameter you know about??
Thanks in advance.
Re: non restrictive ref cursor [message #37052 is a reply to message #37049] Sat, 12 January 2002 08:10 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
i never had any problem while using weak refcursor on nt and 8.1.7. i think there is something wrong in your code. if you post code here, somebody may help you.
Previous Topic: Changing the Port of The Oracle Server
Next Topic: something about column
Goto Forum:

Current Time: Fri May 24 08:36:51 CDT 2024