Donovan,
The following works in Oracle.
CREATE OR REPLACE procedure TEST_PRO
CURSOR CUR IS
SELECT * FROM DONOVAN.TBLCOUNTRIES;
BEGIN
OPEN CUR;
-- insert procedure instructions here
END;
I'm not an Oracle guru and not sure of why it should be done this way. I
think it's because you can't have a SELECT statement between BEGIN and END,
at least not the way you had it.
Toad or SQL+ are the tools I know of that you could use for it.
Best regards,
Sergei Stenkov
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
