Home » RDBMS Server » Server Administration » PL/SQL Oracle 8i select statemet problem
PL/SQL Oracle 8i select statemet problem [message #371977] Fri, 29 December 2000 08:46 Go to next message
Dennis E. Kubes
Messages: 1
Registered: December 2000
Junior Member
I have a script which creates a table opens a declare,begin statement with 3 cursors for calculation, inserts the results as rows into the table, closes the cursors and then I try to select the rows within the declare, begin, end block. Can I do the select statement inside the begin and end block or do I have to break it up into procedures... one for create table, one for calculation and insert, one for select. The error I am getting is that the select must be a select into...but I am trying to get a result set back.

Thanks
DEK

Report message to a moderator

Re: PL/SQL Oracle 8i select statemet problem [message #372010 is a reply to message #371977] Wed, 03 January 2001 12:46 Go to previous message
Ravi Prasad
Messages: 9
Registered: January 2001
Junior Member
hi Dennis

Select into clause has to be used in PL/SQL
u cant directly give select query

u just create another cursor and get the resultset back

bye
ravi

Report message to a moderator

Previous Topic: Problem creating a query
Next Topic: Table Usage/Tree Depedencies
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 10:23:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.