Home » SQL & PL/SQL » SQL & PL/SQL » Can call a cursor in Select statement?
Can call a cursor in Select statement? [message #38131] Fri, 22 March 2002 14:42 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

Is this possible?

declare
CURSOR c2(dn NUMBER) IS SELECT ename, empno FROM emp where deptno = dn ;
BEGIN
SELECT C2(10).ename, C2(10).empno, dname from dept;
END;

Thanks

Report message to a moderator

Re: Can call a cursor in Select statement? [message #38139 is a reply to message #38131] Mon, 25 March 2002 01:56 Go to previous message
Sinthu.K
Messages: 4
Registered: March 2002
Junior Member
Hi,
This is not possible.It gives an internal error.

Thanks

Report message to a moderator

Previous Topic: reading unix files using PL/SQL
Next Topic: LOBs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 07:29:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.